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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql