> -----Original Message-----
> From: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
> Sent: 22 January 2004 00:10
> To: Stephen Frost; Andre Felipe Machado
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Tables/Columns in upper-case?
>
> Take a look at the Database Migration Wizard that comes with
> PgAdminII (and PgAdminIII as well? I haven't checked that
> out).
Nope, no migration wizard in pga3. :-( If there are any bored C++
programmers out there though...
As for the quotes, neither psqlodbc or PostgreSQL will fold them to
uppercase - Access must be doing that.
The rule is, if unquoted, an object name may contain a through z, 0
though 9 or an underscore. If you try to use upper case characters, they
will be folded to lowercase by the server. To use uppercase, or any
other characters in identifiers you must quote them.
Regards, Dave.