Cannot get "WHERE" clause in query to work

[paulb1988]

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??

 

[rski]

How do U write this query?

 

[ceco]

probably you've created the table with UPPER CASE names

so now you have to do

WHERE "ID" = 1