I'm new to PostgreSQL and I ran into problems using the following query:
SELECT * FROM table1 WHERE ID = 1
ERROR: column "id" does not exist LINE 2: WHERE ID = 1
where ID is a column I added via a GUI-tool.
I then found out that ID is a keyword in my current version of PSQL and should be quoted. But I can't recognize what is this ID for.
On the linked page there is the following notice:
It is important to understand before studying Table C-1 that the fact that a key word is not reserved in PostgreSQL (==true) does not mean that the feature related to the word is not implemented.
So, ID is not marked as a PostgreSQL keyword and there seems to be a feature connected to it, but I can't find out which. SELECT ID itself turns into the same error message as posted above.