Search code examples
postgresqlpgadmin

How to make PostgreSQL / pgAdmin behave a bit better with case sensitivity?

I designed a set of tables in pgAdmin. I gave names like Products and ProductRID. I was very surprised though when I went to query this table only to find a query like this yielded unknown relation:

select * from Products

Apparently the proper way to access this is 

select * from "Products"

which is very ugly. I can rename the tables to all lower case to query without quotes, but then it looks ugly. Is there any kind of a setting so that it will retain the case, but behave without case sensitivity?

Solution

  • You may check the relative wiki to get the precise answer

    Why are my table and column names not recognized in my query? Why is capitalization not preserved?

    Hope it clarifies.