Re: Unquoted column names fold to lower case - Mailing list pgsql-sql

On 07/03/2013 11:12 AM, Dev Kumkar wrote:
> 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.

There is no workaround because there is no bug.

> Is there any connection level parameter to flip this behavior?

No.