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
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.