How can I query in psql. If column name like camelCase [duplicate]

Question

My psql table structure like below:

id userName gender  
1   xxxx     Male

if I am using query like below from psql shell:

select * from table where userName="xxx";

It gives error: Error: column "userName" does not exists.

How can I query if column name contain with camelCase.

Answer 1

All identifiers are converted to lower case in postgres. To use upper case identifiers you should use double quotes around identifier to say postgres to not convert it to lower case :

select * from table where "userName" = 'xxx';