Skip site navigation (1) Skip section navigation (2)

Re: error: Relation 'tableName' does not exist ?

From: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
To: "Michael Coughlin" <MPCoughlin4(at)Home(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: error: Relation 'tableName' does not exist ?
Date: 2001-11-05 05:14:31
Message-ID: 20011105050250.274E7636A4@gl.aser.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Monday, 5. November 2001 02:32, Michael Coughlin wrote:
> Unless I create a table, using psql, I've noticed that tables, that I
> created with pgAccess or Microsoft Access, are NOT visible in pSQL
> i.e. I get the error:  "Relation 'tableName' does not exist".  If I
> list tables, using    \d    , psql can "see" the tables; yet, I can't
> select from them without receiving "Relation 'tableName' does not
> exist".

Do the table names contain upper case letters? Then you must quote them, 
like: SELECT * FROM "tableName";

Perhaps this helps a bit?

Christof Glaser
-- 
	  gl.aser . software engineering . internet service
       http://gl.aser.de/ . Planckstra├če 7 . D-39104 Magdeburg

In response to

Responses

pgsql-interfaces by date

Next:From: Michael CoughlinDate: 2001-11-05 15:41:04
Subject: Re: error: Relation 'tableName' does not exist ?
Previous:From: Michael CoughlinDate: 2001-11-05 01:32:01
Subject: error: Relation 'tableName' does not exist ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group