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 Office Base status bar.

Related Topics

• PostgreSQL 13