Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot get "WHERE" clause in query to work

Status
Not open for further replies.

paulb1988

Programmer
Feb 22, 2007
1
US
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??
 
probably you've created the table with UPPER CASE names

so now you have to do

WHERE "ID" = 1

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top