postgres: ERROR: column "catcode" does not exist

Question

I have a postgress table called catcodes. When I do

select Catcode from catcodes;

It gives me an error like this

ERROR:  column "catcode" does not exist
LINE 1: select Catcode from catcodes;

when I describe the table there is a column Catcode.

Column | Type |

-------------+-------------------+

Catcode | character varying |

select * from catcodes

works though.

score 1 · Accepted Answer · answered Aug 09 '18 at 08:25

1

Postgres is case-sensitive, you should try using quotes

SELECT "Catcode" FROM catcodes;

answered Aug 09 '18 at 08:25

Chocolord

Thanks, It works. But could you please tell me why is that. – tsadkan yitbarek Aug 09 '18 at 08:28
I managed to found more explanations ([here](https://stackoverflow.com/a/20880247/3824894)) – Chocolord Aug 09 '18 at 08:46
please can you have a look at this question https://stackoverflow.com/q/51758821/6633337 – Ratan Uday Kumar Aug 09 '18 at 11:23

1 Answers1