Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA36708 for ; Mon, 12 Apr 1999 10:55:31 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA24747; Mon, 12 Apr 1999 10:54:57 -0400 (EDT) To: ghowe1@tampabay.rr.com cc: pgsql-interfaces@postgreSQL.org, dpage@vale-housing.co.uk Subject: Re: [INTERFACES] RE: Problem migrating MSAccess97 table In-reply-to: Your message of Mon, 12 Apr 1999 09:27:26 +0100 Date: Mon, 12 Apr 1999 10:54:57 -0400 Message-ID: <24745.923928897@sss.pgh.pa.us> From: Tom Lane Dave Page writes: > The obvious (and perhaps condescending!) question has to be: are you sure > you are trying to access the same database you migrated to? Next question after that would be whether the table names are lower case or not. Via psql (and anything else that lets you enter raw SQL), table and field names will be folded to lower case unless you put quotes around them. In other words SELECT ... FROM MyTable; --> mytable SELECT ... FROM "MyTable"; --> MyTable But I think pgadmin may supply quotes for you, and if the import process quoted the names too, then you'd have mixed-case or upper-case table names inside Postgres. Try psql's \d command to see what table names the server thinks it has. regards, tom lane