PostgreSQL Connection /text/sdatabase/dabawiz02pgsql.xhp PostgreSQL settings (Base)

PostgreSQL Connection

Specifies the options for connecting to PostgreSQL databases.

DBMS/driver-specific connection string

Enter the driver specific connection string. The connection string is sequence of keyword/value pairs separated by spaces. For example dbname=MyDatabase host=myHost port=5432 where dbname: the name of the database hosted in the DBMS server. host: the fully qualified name of the RDBMS server port: the server port. The default port for PostgreSQL is 5432. You can also enter the connection string as postgresql://myHost:port/MyDatabase. Refer to the database server administrator for the correct values of the keywords passed in the connection string. Values for user= and password= are ignored but will be requested at connection time. The connection string is displayed in the %PRODUCTNAME Base status bar.

List of all keyword/value pairs for PostgreSQL 13 connection string. Not every pair is handled by the %PRODUCTNAME driver manager.