Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2019/10/18 11:45] darya.prikhodkina |
guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2019/11/16 09:51] darya.prikhodkina |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| | **BIN** | Specifies the directory where PSQL.exe utility is located. | | | **BIN** | Specifies the directory where PSQL.exe utility is located. | | ||
| | **USE_EXPLICIT_CURSORS** | This option controls the way cursors will be converted in PostgreSQL database. If this option is set to "Yes", explicit cursor declaration will be used. If set to "No", implicit cursor declaration will be used. \\ Possible values: Yes, No. | | | **USE_EXPLICIT_CURSORS** | This option controls the way cursors will be converted in PostgreSQL database. If this option is set to "Yes", explicit cursor declaration will be used. If set to "No", implicit cursor declaration will be used. \\ Possible values: Yes, No. | | ||
| - | | **REPLACE_NULL_BYTE_WITH** | In PostgreSQL it is not allowed to insert null byte in not BYTEA data type column. So this option controls how the null byte should be changed to make a correct import. \\ If the data type of the inserted column is BYTEA, this option will not work for that case. | | + | | **REPLACE_NULL_BYTE_WITH** | In PostgreSQL it is not allowed to insert null byte in not BYTEA data type column. So this option controls how the null byte should be changed to make correct import. \\ If the data type of the inserted column is BYTEA, this option will not work for that case. | |
| - | | **SET_SEARCH_PATH_TO** | This option will add "SET search_path TO" statement into each sql file generated by the SQLWays Wizard tool. To use this option you need just to specify a schema name that will be used in SET search_path TO statement. \\ By default this option is empty. | | + | | **SET_SEARCH_PATH_TO** | This option will add "SET search_path TO" statement into each sql file generated by SQLWays Wizard tool. To use this option you just need to specify a schema name that will be used in SET search_path TO statement. \\ By default this option is empty. | |
| | **DATA_LOAD_FORMAT** | This option defines the format the data from MSSQL database will be extracted and loaded into PostgreSQL database. Possible values - "HEX" and "OCT". | | | **DATA_LOAD_FORMAT** | This option defines the format the data from MSSQL database will be extracted and loaded into PostgreSQL database. Possible values - "HEX" and "OCT". | | ||
| | **DOLLAR_QUOTED_PGSQL_MASK** | This option controls dollar quotation in the pgsql. The value specified here will be used instead of "$$" in Pl/PgSQL, which is set by default. | | | **DOLLAR_QUOTED_PGSQL_MASK** | This option controls dollar quotation in the pgsql. The value specified here will be used instead of "$$" in Pl/PgSQL, which is set by default. | | ||