Horton
Menu

Re: [GENERAL] Access & pgsql

Oleg Broytmann <phd@fe.msk.ru>

View thread
From: Oleg Broytmann <phd@fe.msk.ru>
To: Juan Carlos Castro y Castro <jcastro@pcshop.com.br>
Cc: pgsql-general@postgreSQL.org
Date: 1998-10-19T14:08:10Z
Lists: pgsql-general 
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.