Lists: | pgsql-interfaces |
---|
From: | "Michael Coughlin" <MPCoughlin4(at)Home(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | tables invisible to pSQL |
Date: | 2001-11-04 00:42:31 |
Message-ID: | 9s22pj$24j9$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
I've noticed that tables, that I created with pgAccess or Microsoft Access,
are NOT visible in
pSQL.
Any attempt in psql to SELECT * FROM tableName;
results in the error:
"Relation 'tableName' does not exist."
I can link from MS Access to the pgAccess tables, just fine. pgaccess can
open the tables, just fine. I'm using the latest version, 7.1.3 of
PostgreSQL. I made sure that the database was not created using "root" and
that I was logged on as another User (which had created the database and
created the tables).
Why? Is there some permissions thing, that I missed?
... any light, that you might shed, would be appreciated,
thanks
Michael Coughlin
From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Michael Coughlin <MPCoughlin4(at)Home(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: tables invisible to pSQL |
Date: | 2001-11-05 20:17:29 |
Message-ID: | 3BE6F3D9.656F941B@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
Michael Coughlin wrote:
>
> I've noticed that tables, that I created with pgAccess or Microsoft Access,
> are NOT visible in
> pSQL.
>
> Any attempt in psql to SELECT * FROM tableName;
> results in the error:
> "Relation 'tableName' does not exist."
Try
#> SELECT * FROM "tableName";
as Access creates the tables eaxctly as you name them, you must use ""
using SELECT * FROM tableName; triest to access table "tablename"
------------
Hannu