Обсуждение: tables invisible to pSQL

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

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

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