Specifies the options for connecting to PostgreSQL databases.
The data for the direct connection to a PostgreSQL database can be provided in two different ways:
Connection data can be provided by filling in the top three text boxes. Ask the database administrator for the correct data.
Database name: type the name of the specific database.
Server: provide the URL or IP address of the DBMS server.
Port number: enter the port number of the DBMS server.
Instead of entering the data in the text boxes as explained above, or if you need to specify more parameter for the connection, you can enter the driver specific connection string. The connection string is a sequence of keyword/value pairs separated by spaces. For example
dbname=MyDatabase host=myHost port=5432
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
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 LibreOffice Base status bar.