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> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: rsanford@nolimitsystems.com
Subject: Re: case sensitivity?
In-Reply-To: <HOEFIONAHHKFEFENBMNOGEJGCBAA.rsanford@nolimitsystems.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox