Please check the attached image. My question is can we get the column name in upper case?
Reading the Table: Can we get the column name in an upper case while reading the column using AS keyword?
PostgreSQL converts all table column names into lowercase, unless quoted.
So please put a quote (“TEST”) on the column.
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