> -----Original Message----- > From: Garry Rothert [mailto:[EMAIL PROTECTED]] > Sent: 07 February 2003 15:36 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Problem selecting data > > > Hi > I've migrated an access database into PostgreSQL using the > migration. Everything > seems to have worked, but I can't see the tables in the > PGADMIN tree. Also when I try > and select the data I get the following.
Hi Garry, What do you see in the tree? > ERROR: Relation "tablename" does not exist. Did the tables have mixed case names, or odd characters (such as spaces) in them? If so, try double quoting their names in your SQL. Alternatively, rerun the migration with the option to shift the names to lower case switched on (it's on the first page). Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
