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

Re: "Invisible" relations after migrating Access

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <barliant(at)duabelas(dot)net>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: "Invisible" relations after migrating Access
Date: 2002-06-13 06:58:34
Message-ID: D85C66DA59BA044EB96AB9683819CF6101538A@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Are there any upper case letters or other odd characters in the
tablename? If so, you need to put double quotes around it:

SELECT * FROM "My Table";

Regards, Dave.

> -----Original Message-----
> From: Anung B. Ariwibowo [mailto:barliant(at)yahoo(dot)com] 
> Sent: 13 June 2002 07:12
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] "Invisible" relations after 
> migrating Access
> 
> 
> Hi fellow pgadmin users,
> 
> I have difficulties when issuing a select statement under 
> psql in a database which is migrated from Microsoft Access.
> 
> I have a MSAccess97 database migrated to PostgreSQL 7.2 using 
> PgAdminII. The migration process was successful, however, 
> when I tried to access the tables using psql in Linux, I got 
> this error message:
> 
> ERROR:  Relation "tablename" does not exist.
> 
> But when I tried to list all relations in the database using 
> \d, they showed up. It it "invisible" when I tried to 
> "Select"-ing via SQL statement. Even trying to "Alter table 
> tablename owner to dbuser" results in same error message above.
> 
> Why this happened? Anyone ever seen such problems? Any hints 
> would be appreciated. TIA,
> --
> Ag.B -- barliant(at)yahoo(dot)com
> 
> =====
> --
> Ag.B -- barliant(at)duabelas(dot)net
> The Prophet Muhammad (peace be upon him) said: "If Judgment
> Day comes when you are planting a seedling, if you are able
> to plant it before the Day arrives, do so."
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup 
http://fifaworldcup.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

pgadmin-support by date

Next:From: mimimcgreDate: 2002-06-13 12:55:17
Subject:
Previous:From: Anung B. AriwibowoDate: 2002-06-13 06:11:50
Subject: "Invisible" relations after migrating Access

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