Re: tables invisible to pSQL - Mailing list 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