Horton

Re: PostgreSQL said: ERROR: Attribute 'id' not found

Doug McNaught <doug@wireboard.com>

View thread View on postgr.es
From: Doug McNaught <doug@wireboard.com>
To: eric.jones@hua.army.mil
Cc: pgsql-general@postgresql.org
Date: 2002-04-10T00:14:10Z
Lists: pgsql-general 
eric.jones@hua.army.mil writes:

> Hello All!
> 
> Version - 7.2.1
> OS - FreeBSD
> 
> 	I've encountered the following error when ever doing a select
> statement on any table in my DB:
> 
> PostgreSQL said: ERROR: Attribute 'id' not found 
> 
> 	The select statement I'm doing is:
> 
> 		select * from s_users where ID = 1;

Try this:

SELECT * from s_users where "ID" = 1;

-Doug
-- 
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...