Michael Coughlin wrote:
> I've noticed that tables, that I created with pgAccess or Microsoft Access,
> are NOT visible in
> Any attempt in psql to SELECT * FROM tableName;
> results in the error:
> "Relation 'tableName' does not exist."
#> 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"
In response to
pgsql-interfaces by date
|Next:||From: Llew||Date: 2001-11-06 20:53:09|
|Subject: COPY from files does not work|
|Previous:||From: Michael Coughlin||Date: 2001-11-05 15:41:04|
|Subject: Re: error: Relation 'tableName' does not exist ?|