Re: [GENERAL] Case sensitivity

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Dana Powers <powersdp(at)ctrvax(dot)Vanderbilt(dot)Edu>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] Case sensitivity
Date: 1999-09-20 04:05:41
Message-ID: 199909200405.AAA06865@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.

--
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jose Antonio Cotelo lema 1999-09-20 08:04:25 Problems when opening large objects in the server side.
Previous Message Dana Powers 1999-09-20 03:43:00 Case sensitivity