Re: "Invisible" relations after migrating Access

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@yahoo.com]
> Sent: 13 June 2002 07:12
> To: pgadmin-support@postgresql.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@yahoo.com
>
> =====
> --
> Ag.B -- barliant@duabelas.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