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

Question

I developed a set of tables in pgAdmin. I gave names like Productsand ProductRID. I was very surprised, though, when I went to query this table to find a query like this gave an unknown relation:

select * from Products

Apparently the correct way to access it is

select * from "Products"

which is very ugly. I can rename tables to all lowercase for a query without quotes, but then it looks ugly. Is there any parameter to keep this case, but behave case-insensitive?

Answer 1

You can check the relative wiki to get an exact answer.

? ?

, .

Answer 2

. - , . , ( ) . " " , ​​

SELECT * FROM Products

.