Re: psql problem - Mailing list pgsql-sql

From Mitch Vincent
Subject Re: psql problem
Date
Msg-id 012001bfcb26$bb8032c0$4100000a@venux.net
Whole thread Raw
In response to psql problem  (Rick Parker <Rick_Parker@boscomm.net>)
List pgsql-sql
> > Does anyone know why when I am in a particular DB as user postgres and
use
> > the following statement, why I get this error?"
> >
> > This is the statement;
> > SELECT * FROM some_file where ID = 1;
> >
>
> --------------------------------------------------------------------------
--
> > Error: ERROR:  attribute 'id' not found
> > Execution time 0.02 sec.

That indicates that you have no column named 'id'..

> > But if I use the following statement, everything is returned fine.
> >
> > SELECT * FROM servlet_file;

That's a totally different query which would yeild totally different
results..

-Mitch





pgsql-sql by date:

Previous
From: Ed Loehr
Date:
Subject: Re: psql problem
Next
From: mikeo
Date:
Subject: TOP SESSIONS?