Navigation:  GeoOffice ePaper designer > Dictionary - Features > Description of the Actions > New Element > New Connection & New Data Source > PostgreSQL-Connection

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

 

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

 

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)

 

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

 

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

 

 

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

 

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

 

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

 

Note: The select statement, by default, uses "" for querying the tables. This makes it possible to use table names with uppercase letters. Table names with "" are handled as case-sensitive. Table names without "" are converted to lowercase letters.

e.g.: Select * from "Table"

e.g.: Select * from table