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:[EMAIL PROTECTED]] > Sent: 13 June 2002 07:12 > To: [EMAIL PROTECTED] > 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 -- [EMAIL PROTECTED] > > ===== > -- > Ag.B -- [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
