Re: relation problem

Things to check: set the right PGUSER? Connected to the database you
expected?

I tend to mistrust pgaccess, not because it's a bad tool (it's quite good
actually), but because of the chances for newbie pilot error. I stick with
psql for experimentation. I can run my select/insert/create/drop and so on
with the minimum of layers between me and the database engine.

Ciao
 --Louis  <louis@bertrandtech.on.ca>


On Wed, 14 Mar 2001, Dax Duskin wrote:

> Hi everybody:
>
> I created a table using pgaccess and put some sample data in it.  When I went to
> run a query on it psql I found that there was no relation.  "Relation does not
> exist."  It looks like I completely lost my table.  I'm just glad it wasn't real
> data.  I also tried running a perl script with a query to the table and it
> returned an error.
>
> Any ideas as to what is going on?
>
> Thanks,
> Dax Duskin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>