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

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.

Apart from the case-sensitivity problem: String constants need to be put in single quotes in SQL, double quotes are for identifiers. `"xxx"` refers to a column named `xxx` but `'xxx'` is a string literal — , May 16 '17 at 07:45

score 22 · Accepted Answer · answered May 16 '17 at 06:50

22

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';

answered May 16 '17 at 06:50

mohammad

2,232
1
18
38

Thanks! This applies to camelCase names of tables as well--as OP said, "all identifiers!". – izikandrw May 04 '21 at 15:28

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

1 Answers1