Something to check:
Case sensitivity. If you create a table in pgaccess with a capital
letter in it, when querying the table in psql you will need to put the
table name in quotes "".
SELECT * FROM "Table";
Jeff Daugherty
Database Systems Engineer
Great Bridge, LLC
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
>
>