PostgreSQL said: ERROR: Attribute 'id' not found

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;

This fails when I do an "ID" or an "id".

I've tried it both in PHP PG Admin and from the command line.

My table looks like this:

CREATE TABLE "s_users" (
"ID" int8 DEFAULT nextval('"s_users_seq"'::text) NOT NULL,
"fname" text NOT NULL,
"lname" text NOT NULL,
"ako" text NOT NULL,
"phone" text,
"email" text NOT NULL,
"rank_id" int8,
"status_id" int8 DEFAULT 2 NOT NULL,
CONSTRAINT "s_users_pkey" PRIMARY KEY ("ID")
);

Anyone know why this is happening and how to fix it? Thanks in
advance!

Eric Jones (Contractor)
FDIC Web Enabler
E-mail: jonese(at)hua(dot)army(dot)mil
Office - 520-533-6628
Cell - 520-930-2136
Email Pager - 5209802136(at)messaging(dot)nextel(dot)com