From: "Robert J. Sanford, Jr." <rsanford@nolimitsystems.com>
To: <pgsql-general@postgresql.org>
Subject: case sensitivity?
Date: Sun, 26 Aug 2001 16:06:14 -0500
Message-ID: <HOEFIONAHHKFEFENBMNOGEJGCBAA.rsanford@nolimitsystems.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal

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