Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:vpostgres-section [October 26, 2018, 12:31:28 PM]
alexandr.kirpichny created
sqlways:command-line:sqlways-ini:vpostgres-section [March 29, 2019, 11:38:56 AM] (current)
darya.prikhodkina
Line 6: Line 6:
 ====== Sqlways.ini File - Section [VPOSTGRES] ====== ====== Sqlways.ini File - Section [VPOSTGRES] ======
  
-This article describes sqlways.ini file [VPOSTGRES] section and options it contains. +This article describes sqlways.ini file's [VPOSTGRES] section and options it contains. 
 ^  Option name  ^ Description  ^  ^  Option name  ^ Description  ^ 
-| **HOST** | This option sets the host name where import will be done. | +| **HOST** | This option sets host name where import will be performed. | 
-| **DATABASE** | This option sets the database name where import will be done. | +| **DATABASE** | This option sets database name where import will be performed. | 
-| **USER** | This option sets user account that will be used to connect to vPostgres database.   | +| **USER** | This option sets user account that will be used to connect to vPostgres database.   | 
-| **PWD** | This option sets password that will be used together with the user account to connect to vPostgres database.   | +| **PWD** | This option sets password that will be used together with the user account to connect to vPostgres database.   | 
-| **PORT** | This option sets port number that will be used to connect to vPostgres database. | +| **PORT** | This option sets port number that will be used to connect to vPostgres database. | 
-| **TARGET_VERSION** | This option sets the version number of the database where import will be done. | +| **TARGET_VERSION** | This option sets version number of the database where import will be performed. | 
-| **BIN** | This option sets the path to the native utility that will be used by SQLWays Wizard tool to make an import into the vPostgres database. | +| **BIN** | This option sets the path to the native utility that will be used by SQLWays Wizard tool to perform import into vPostgres database. | 
-| **TABLES_WITH_OIDS** | This option defines whether the tables will be created with OID. OID column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. By default this option is set to "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | +| **TABLES_WITH_OIDS** | This option defines whether tables will be created with OID or not. OID column is a system column created for each table. It contains unique identifier for the row of data in database and can be used as a unique pointer to the exact record in the database. By default this option is set to "Yes". This means that all CREATE TABLE statements will be created with WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | 
-| **TABLESPACE** | In this option can be specified tablespace name that will be used in CREATE TABLE statements in vPostgres. \\ Default value - Empty. | +| **TABLESPACE** | In this option you can specify tablespace name that will be used in CREATE TABLE statements in vPostgres. \\ Default value - Empty. | 
-| **INDEX_TABLESPACE** | In this option can be specified tablespace name that will be used in CREATE INDEX statements in vPostgres. \\ Default value - Empty. | +| **INDEX_TABLESPACE** | In this option you can specify tablespace name that will be used in CREATE INDEX statements in vPostgres. \\ Default value - Empty. | 
-| **USE_SOURCE_TABLESPACE_NAMES** | This option defines whether the original tablespace names will be used in the converted object definitions. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |+| **USE_SOURCE_TABLESPACE_NAMES** | This option defines whether original tablespace names will be used in the converted object definitions. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
  
  
sqlways/command-line/sqlways-ini/vpostgres-section.txt · Last modified: March 29, 2019, 11:38:56 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement