From: Tom Lane <tgl@sss.pgh.pa.us>
To: ghowe1@tampabay.rr.com
Cc: pgsql-interfaces@postgreSQL.org
Cc: dpage@vale-housing.co.uk
Subject: Re: [INTERFACES] RE: Problem migrating MSAccess97 table
Date: Mon, 12 Apr 1999 10:54:57 -0400
Message-ID: <24745.923928897@sss.pgh.pa.us> (raw)
In-Reply-To: <C13176CD0FE1D21189E4006097BCD3D6E5EA@woody.vale-housing.co.uk>
Dave Page <dpage@vale-housing.co.uk> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, ghowe1@tampabay.rr.com, dpage@vale-housing.co.uk
Subject: Re: [INTERFACES] RE: Problem migrating MSAccess97 table
In-Reply-To: <24745.923928897@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox