Unquoted column names fold to lower case
От
Dev Kumkar
Тема
Unquoted column names fold to lower case
Дата
Msg-id
CALSLE1PeLH4iqEyT5RH=d4Y3VmrRyxm6rvnV9fNC0++u9h-WWw@mail.gmail.com
Список
Дерево обсуждения
Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Theodore Petrosky <tedpet5@yahoo.com>
Re: Unquoted column names fold to lower case Thomas Kellerer <spam_eater@gmx.net>
Re: Unquoted column names fold to lower case Bruce Momjian <bruce@momjian.us>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Bruce Momjian <bruce@momjian.us>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Tom Lane <tgl@sss.pgh.pa.us>
Re: Unquoted column names fold to lower case Bruce Momjian <bruce@momjian.us>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Thomas Kellerer <spam_eater@gmx.net>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Unquoted column names fold to lower case creechy <mock@fakebelieve.org>
Re: Unquoted column names fold to lower case Tom Lane <tgl@sss.pgh.pa.us>
Re: Unquoted column names fold to lower case Bruce Momjian <bruce@momjian.us>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Bruce Momjian <bruce@momjian.us>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
Re: Unquoted column names fold to lower case Vik Fearing <vik.fearing@dalibo.com>
Re: Unquoted column names fold to lower case Dev Kumkar <devdas.kumkar@gmail.com>
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.
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!
В списке pgsql-sql по дате отправления
От: rawi
Дата: