Sender: dpowers@nagpur.quicknet.net
Message-ID: <37E6691B.9B6C77C7@fphome.com>
Date: Mon, 20 Sep 1999 10:04:27 -0700
From: Dana Powers <dana@fphome.com>
MIME-Version: 1.0
To: pgsql-general@hub.org
Subject: Re: [GENERAL] Case sensitivity
References: <199909201632.MAA05831@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bruce Momjian wrote:
> 
> > > > 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
> > 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.
> 
Problem is, I don't have control over the client queries. Third party
closed source contact manager. So I guess I'll try to hack something
together. Thanks Bruce
Dana