Re: PostgreSQL said: ERROR: Attribute 'id' not found - Mailing list 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...