Postgres Pro
Downloads
Home   >   mailing lists

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

From Dev Kumkar
Subject Unquoted column names fold to lower case
Date
Msg-id CALSLE1PeLH4iqEyT5RH=d4Y3VmrRyxm6rvnV9fNC0++u9h-WWw@mail.gmail.com
Whole thread Raw
Responses Re: Unquoted column names fold to lower case
Re: Unquoted column names fold to lower case
List pgsql-sql
Tree view
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...

pgsql-sql by date:

Previous
From: rawi
Date:
Subject: Re: Index Usage and Running Times by FullTextSearch with prefix matching
Next
From: Dev Kumkar
Date:
Subject: Re: Unquoted column names fold to lower case