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.

Chocolord · Accepted Answer · 2018-08-09 08:25:40Z

1

Postgres is case-sensitive, you should try using quotes

SELECT "Catcode" FROM catcodes;

answered Aug 9, 2018 at 8:25

Chocolord

4913 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Thanks, It works. But could you please tell me why is that.

I managed to found more explanations (here)

please can you have a look at this question stackoverflow.com/q/51758821/6633337