Reading the Table: Can we get the column name in an upper case while reading the column using AS keyword?


Please check the attached image. My question is can we get the column name in upper case?

PostgreSQL converts all table column names into lowercase, unless quoted.

So please put a quote (“TEST”) on the column.

Thanks Arunesh…
I tried with single quotes but it didn’t work for me so asked this question. It seems single and double quotes have different usage in SQL unlike python where it is same.

Yes we have to use only double quotes for column names and for values in the columns use single quotes