Re: Tables/Columns in upper-case?

Hello,
I guess that it is an Access issue or its MS driver, because I use OpenOffice
1.1 connected to a PostgreSQL through odbc and can use upper or lower case.
Actually, odbc adds double quotes in sql commands to encapsulate upper case
names in order to work in pg.
It will be not a good idea to incorporate specific programs "features" into a
generic driver manager. Maybe into an Access odbc driver...
Suggestion:
After exporting to PostgreSQL, execute a dump to a text file.
Then, edit it to use only lower case and execute the sql into pg to create new
lowercase tables.
Good luck.
Andre Felipe
http://www.andrefelipemachado.hpg.ig.com.br/linux/index.html
Brazilian portuguese