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

eric(dot)jones(at)hua(dot)army(dot)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...