<< Click to Display Table of Contents >> Navigation: Connectors > PostgreSQL > Connection Parameters |
Connection String |
The connection string JDBC will use to connect to the DB, of the following form: jdbc:postgresql://<hostname>:<port>/<db_name> e.g.: jdbc:postgresql://172.16.10.242:5432/test_db
|
Username |
Username for the user through which DTS will connect to the DB. |
Password |
Password for the user. |
Schemas |
The names of the schemas DTS should access, separated by commas. |
Port is optional
The <port> can be skipped in the connection string if using the default port (5432).
Schemas are optional
If the Schemas field is left empty, DTS will access all the schemas in the database that the specified user can.