Re: ERROR: column "id" does not exist

On Mon, Nov 15, 2004 at 01:44:47PM +0100, Sandro Daehler wrote:

> SELECT MAX(id) FROM apconfig;
>
> if i send this statement i got the following error:
>
> ERROR: column "id" does not exist
>
> Can anyone explain me this error? There is the column id, and there are
> also entries in it.

The column might have a different case or possibly leading or
trailing spaces, in which case you'll have to quote it verbatim.
What does \d apconfig show? If that doesn't show the problem
then try this:

SELECT quote_ident(attname) FROM pg_attribute
WHERE attrelid = 'apconfig'::regclass;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/