Hi!
On Mon, 19 Oct 1998, Juan Carlos Castro y Castro wrote:
> I created tables and fields in a pgsql database with mixed-case names.
> like: Teams, Pilots, Drivers, FullName etc.
> Then I linked a MS-Access database to the pgsql database, thru PsqlODBC
> (latest version).
> All table and field names appear in lowercase in Access. Why?
This is normal SQL behavior - tables/fields are case-insensitive. If you
want case-sensitive names, surround them with double-quotes:
"FullName", "Drivers", etc.
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.
