From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Dana Powers <dana(at)fphome(dot)com> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Case sensitivity |
Date: | 1999-09-20 16:32:13 |
Message-ID: | 199909201632.MAA05831@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > > 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Dana Powers | 1999-09-20 17:04:27 | Re: [GENERAL] Case sensitivity |
Previous Message | Dana Powers | 1999-09-20 15:58:50 | Re: [GENERAL] Case sensitivity |