RE: [SQL] psql problem

[Volker Paul]

Does anyone know why when I am in a particular DB as user postgres and use
the following statement, why I get this error?" 

This is the statement;
SELECT * FROM some_file where ID = 1;

[Volker Paul]  If your ID field is really uppercase, try:
SELECT * FROM some_file where "ID" = 1;

Cheers,

Volker