sorry, but you misunderstand. this is the correct behavior of SQL. It is part of the specification to do this.
--- On Wed, 7/3/13, Dev Kumkar <devdas.kum...@gmail.com> wrote: > From: Dev Kumkar <devdas.kum...@gmail.com> > Subject: [SQL] Unquoted column names fold to lower case > To: pgsql-sql@postgresql.org > Date: Wednesday, July 3, 2013, 5:12 AM > 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... > > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
