What are the criteria for determining "required or not in a Postgresql query?"

Question

I am starting with Postgresql, I converted MS SQL DB, but I can not understand why

SELECT * FROM MYTABLE

does not work

and

SELECT * FROM "MYTABLE" does

In addition, from another computer connecting to the same database, I can run

SELECT * FROM MYTABLE --(without ")

All tests were performed using the PGAdmin III Windows client. Postgresql is installed on a Linux server.

This is a question with a PG newbie, hope you can help.

Answer 1

By default, postgresql converts unquoted identifiers into an SQL statement in lower case; this is not the same as case insensitive.

, "", "", "".

, , postgresql: , , , (the_thing). , :

• , , .
• .

: , , .

PS "table". , () . , "select * from table" , , , .