Thanks John. 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 <pie...@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 > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- :o) dev
