Close popover
Kensho Tsuchihashi (TSUCK)
Project Delivery Leader
Pegasystems Inc.
TSUCK Member since 2010 126 posts
Posted: April 30, 2020
Last activity: June 15, 2020

Upper case and Lower case issue with PostgreSQL database


In PostgreSQL, database objects name (column name, table name, etc) are handled in lower case. This is by their design, and it's not up to us. Let's say, we create a class and properties with letters that starts with upper case (This is a Java/Pega standard practice) as below.

Class & Properties with Upper Case and Lower Case

Pega Platform automatically creates a table and columns as below - all with lower case letters.

PostgreSQL Table and Column with all lower case

This causes an issue. For example, if I use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence I can't reference to the data by Property name.

data loaded with lower cases

In order to avoid this issue, I have to map them in the class form as below.

External Mapping

This issue has been a while but is there any enhancement yet? This bug doesn't happen in Oracle.


FYI, below link talks about the same issue but there is not applicable solution provided.





***Edited by Moderator Marissa to update Platform Capability tags****

Pega Platform 8.4 Data Integration