Can I make PostgreSql namespace case-insensitive?
Can I make PostgreSql namespace case-insensitive?
От:
Ben Kim <bkim@coe.tamu.edu>
Дата:
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
Re: Can I make PostgreSql namespace case-insensitive?
От:
Manuel Sugawara <masm@fciencias.unam.mx>
Дата:
Ben Kim 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.