This functionality is only available for certain module packages.

You are here: EEC > BASE > Data sources > Data source objects > DatabaseDataSource > PostgreSQL

PostgreSQL

All table and column names are converted to lowercase letters: i.e., all table and column names are then expected in lowercase letters by the database as well.

If uppercase letters are to be supported as well, all SQL requests must be placed in quotes.

The style of the column names in the results corresponds to the table definition.

‘select customernumber from customer’ works.

‘select PartNumber from Parts’ does not function.

‘select “PartNumber” from “Parts”’ works.