PostgreSQL Reader Parameters

Database Connections

Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections.

Note that Database Connection parameters may differ slightly, depending on context and/or database format.

Connection Parameters

Note: The source and destination dataset must be set to the database name.

Note: If you are having trouble connecting to the database, ensure you can connect to the database with the host, port, database, username, and password using psql. See PostgreSQL documentation for proper security and connection information, and for the usage of the psql utility.

Constraints

Schema Attributes

Advanced