I'm querying a simple 3-column table with ID (int), ACK (boolean), DESCRIPTION (text). In the pgAdminIII query tool, if I do a SELECT * FROM MYTABLE, then I get all my rows. However, when I try to add a restriction via a WHERE clause (such as ID = 1), then I get:
ERROR: column "id" does not exist
SQL state: 42703
Character: 33
Any ideas??
ERROR: column "id" does not exist
SQL state: 42703
Character: 33
Any ideas??