Yes CITEXT would work, the only thing its needs DDL changes across and hence was looking for any such global database parameter setting while creating database. I have been looking at other discussions and doesn't look like anything of that coming up soon that makes database case insensitive.
regards...
On Wed, Dec 11, 2013 at 12:10 PM, John R Pierce <pierce@hogranch.com> wrote:
On 12/10/2013 10:31 PM, Dev Kumkar wrote:
I know about CITEXT data type, but what am looking for is if there any parameter at database level which just makes the database case insensitive.
there's nothing that will do that in postgres.
whats wrong with using CITEXT ?
-- john r pierce 37N 122W somewhere on the middle of the left coast