Обсуждение: Can I make PostgreSql namespace case-insensitive?

Dear List,

Is there a way to completely turn off case sensitivity of the names of
table, field, sequence, etc.?

In our case we used mixed-case names, and the names are unique. They
wouldn't collide even if they get turned into lowercase names.

Because of interfacing problems with other softwares, I wish to make all
names case insensitive. However we already have some scripts using case
sensitive names, so don't want just to convert the database to lowercase
only. This is why I am looking to turn off case sensitivity of the
database as a whole. (So that "MyTable", mytable, MyTable will all work.)

I would appreciate any advice.


Regards,
Ben

Ben Kim <bkim@coe.tamu.edu> writes:

> Dear List,
>
> Is there a way to completely turn off case sensitivity of the names
> of table, field, sequence, etc.?

No, i'm afraid not. But you can tweak scan.l to teach postgreSQL do
what you want.

Regards,
Manuel.