case sensitivity?

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: case sensitivity?
Date: 2001-08-26 21:06:14
Message-ID: HOEFIONAHHKFEFENBMNOGEJGCBAA.rsanford@nolimitsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

setup - pgsql 7.1.2 cygwin binary distribution

i first noticed this when running psql - whenever i
perform a select all of the columns are returned as
all lowercase. that wasn't too disturbing, i just
found it to be slightly odd.

what was disturbing was when the same thing happened
going through the odbc driver on win32 and all of my
old perl code that worked under microsoft stopped
working under postgres because i was looking for
keys in the hash retrieved by the $dsn->dataHash()
by the MixedCase names that i used to create the
tables with in the sql.

that meant that i had to run through my code to
modify all of the hash references to all lowercase.
needless to say, that was a pain.

is there any setting that will allow postgres to
keep mixed case column names when creating a db?

rjsjr

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-26 21:09:20 Re: problems on solaris 7
Previous Message Cody 2001-08-26 20:50:16 Re: SELECT FOR UPDATE