The PostgreSQL Connection is used to query data from a PostgreSQL database.

 

Define the name of the connection and press Build ...

New PostgreSQL connection

New PostgreSQL connection

 

For the PostgreSQL connection by default the following settings are displayed:

•Host (Default: 127.0.1)

•Port (Default: 5432)

•User (Default: postgres)

•Database (Default: postgres)

 

Default settings

Default settings

 

Edit the parameters according to your database settings and enter the password.

 

Press Test Connection to test the connection to your PostgreSQL database.

Connection settings including password

Connection settings including password

 

If the connection is tested successfully, the tables can be added. Add the tables via the function New Data Source .... Select your PostgreSQL Connection.

Choose data source

Choose data source

 

The tables of the PostgreSQL database are listed under the node tables. Select the desired tables from the list.

Select tables

Select tables

 

The tables are added to your dictionary and are now available as epaper data source.

 

icon_comment

The select statement, by default, is used for the from Table query. This makes it possible to use table names with uppercase letters. Table names are handled as case-sensitive. Table names without are converted to lowercase letters.

e.g.: Select * from Table

e.g.: Select * from table