RE: [GENERAL] case problem with MS Access export

I have successfully exported my Access97 databases to PostgreSQL without the
case problem you describe. I have posted my notes and the Access97 database
I used to export my data in this web page:

www.sevainc.com/Access <http://www.sevainc.com/Access>

I did not use pgAdmin.

Thanks, Michael

-----Original Message-----
From: Glenn Waldron [SMTP:gwaldron(at)wareonearth(dot)com]
Sent: Thursday, April 15, 1999 6:15 AM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] case problem with MS Access export

I've seen this question elsewhere on the list, but no good answer.
I am exporting large databases from MS Access to PG, but the table
and column names come out as case-sensitive in PG and I need to
quote them in order for PG to see them.

select * from table tab1;

gives an error because the table name is actually "TAB1", but SQL is
supposed to be case-insensitive. I understand that I can quote
everything and it will work, but this breaks tons of existing SQL
code.

Is there a better solution??? It would be nice for example, if
pgAdmin had such an option in its MS Access migration... -glenn

---
Glenn Waldron, WareOnEarth Inc. * v 703/847-2969 * f 703/847-2538