Re: relation X does not exist

Laura Scott <l(dot)e(dot)scott(at)larc(dot)nasa(dot)gov> writes:
> I have a table defined with only two fields. The create table statement
> did not have " " around the table name. I can cut and paste the query
> from my debug statement into psql and get the desired result set back.
> However, in the .pgc file, the query no matter how I write it (with " "
> , without, uppercase....) I get the relation X does not exist.

Are you sure your ecpg program is connecting to the same database as
you're using manually? Perhaps it's connecting as a different userid
that has a different search path?

regards, tom lane