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.On Wed, Dec 11, 2013 at 12:10 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 12/10/2013 10:31 PM, Dev Kumkar wrote:there's nothing that will do that in postgres.
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.
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
:o) dev
