Hello,
All unquoted identifiers are assumed by PostgreSQL to be lower case by default. This means
- SELECT MY_COLUMN FROM my_table
- SELECT my_column FROM my_table
- SELECT my_column as MY_COLUMN FROM my_table
All refer to my_column and has column name in lowercase as my_column.
If the aliases are in upper case and quoted then those are returned in upper case.
- SELECT my_column as "MY_COLUMN" FROM my_table
Is there any workaround to set the alias columns to be returned as upper case with adding quotes. Is there any connection level parameter to flip this behavior?
Thanks in advance!
Regards...