| From: | Oleg Broytmann <phd(at)fe(dot)msk(dot)ru> |
|---|---|
| To: | Juan Carlos Castro y Castro <jcastro(at)pcshop(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Access & pgsql |
| Date: | 1998-10-19 14:08:10 |
| Message-ID: | Pine.SOL2.3.96.SK.981019180648.13239C-100000@sun.med.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Broytmann | 1998-10-19 14:10:47 | Re: your mail |
| Previous Message | Anton de Wet | 1998-10-19 14:04:43 |