Connect to Postgre SQL

Click “New” on the Connectionmenu.

Select “PostgreSQL”.

Connection name: enter a connection name.

Server name: enter the PostgreSQL Server name.

Database: enter the database name.

User: enter the user name.

Password: enter the database password.

Enable Offline mode: Learn more here.

Select User Groups who can view the Connection: assign user groups with privileges to open objects from this connection.

Click “Ok” to establish the connection.

Important! In order to fully exploit all MS Excel © export functionality it is recommended that you install the psqlODBC driver.

Please download and install form here.