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
>