Sqlways.ini File - Section [VPOSTGRES]

This article describes sqlways.ini file's [VPOSTGRES] section and options it contains.

Option name	Description
HOST	This option sets a host name where import will be performed.
DATABASE	This option sets a database name where import will be performed.
USER	This option sets a user account that will be used to connect to vPostgres database.
PWD	This option sets a password that will be used together with the user account to connect to vPostgres database.
PORT	This option sets a port number that will be used to connect to vPostgres database.
TARGET_VERSION	This option sets a 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 perform import into vPostgres database.
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 a unique identifier for the row of data in a database and can be used as a unique pointer to the exact record in the database. By default this option is set to “No”. This means that all CREATE TABLE statements will be created with WITH OIDS option. Possible values - “Yes”, “No” or Empty. Default value - “No”.
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 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 original tablespace names will be used in the converted object definitions. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty.

Example:

[VPOSTGRES]
HOST=hostname
DATABASE=test
USER=postgres
PORT=4444