PostgreSQL disable auto lowercase column name

1.1k Views Asked by At

I have created a PostgreSQL database 12.7 and converted it to an esri geodatbases, then I copied the tables and feature classes from a file geodatabases , this caused the al column names to be lowercases however we are already integrating with an API that is case sensitive and needs the column names as per the design example IDs are upper case and fields are camle case.

is there any PostgreSQL setting to disable this auto to lower column names? because when we quoted the column names the gis system could not find the columns with quoted names.

1

There are 1 best solutions below

0
progowl On

The only way to prevent PostgreSQL from folding into lowercase is to use double quoted identifiers. This is already sort of answered here. It also includes a link to the manual on identifiers.