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";
> -----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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
pgadmin-support by date
|Next:||From: mimimcgre||Date: 2002-06-13 12:55:17|
|Previous:||From: Anung B. Ariwibowo||Date: 2002-06-13 06:11:50|
|Subject: "Invisible" relations after migrating Access|