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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | mimimcgre | 2002-06-13 12:55:17 | |
Previous Message | Anung B. Ariwibowo | 2002-06-13 06:11:50 | "Invisible" relations after migrating Access |