From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909201632.MAA05831@candle.pha.pa.us>
Subject: Re: [GENERAL] Case sensitivity
In-Reply-To: <37E659BA.A1BA8EFF@fphome.com> from Dana Powers at "Sep 20, 1999
	08:58:50 am"
To: Dana Powers <dana@fphome.com>
Date: Mon, 20 Sep 1999 12:32:13 -0400 (EDT)
CC: pgsql-general@hub.org
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> > > I am evaluating whether it is possible to migrate our Contact manager
> > > system to Postgres on Linux, but I am having difficulty because the
> > > client software was most moronically programmed to access tables using
> > > wildly different case structures, i.e. a table might be created
> > > 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on
> > > the context. Is there anyway to disable case-sensitivity in this case,
> > > either through Postgres config, or the ODBC drivers? I have no access to
> > 
> > We have no trouble accessing tables with different case.  TABLE, Table,
> > table and taBLe are all the same to us, unless you put the table name in
> > double-quotes.
> 
> The problem is, if you create a table without "", the table name
> defaults to lower case, and all non ""ed references to the table also
> default to all lower case but if you create a table with ""s you cannot
> access it unless you specify all references to it also in ""s. My
> question is, is there anyway to nullify the "" behavior and set all
> tables to lowercase?

So you are creating with quotes, but want to access it without quotes? 
Can't do that.  Why not just remove the quotes from the queries?  I
suppose you could hack out the quote stuff to force everything to
lowercase, even if it has quotes.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026