Postgres Pro
Downloads
Home   >   mailing lists

Case sensitivity - Mailing list pgsql-general

From Dev Kumkar
Subject Case sensitivity
Date
Msg-id CALSLE1ND5tbXYwB=rbnbaTW4_nRCjr5uofK7nKxtN3M9PE42YQ@mail.gmail.com
Whole thread Raw
Responses Re: Case sensitivity  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
How to create case insensitive database?

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.

I mean both values 'ABC' and 'abc' are treated same for inserts and also all the comparisons by default are case insensitive.

Was not able to find anything concrete forums, hope I didn't overlook anything here.

Regards...
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trigger Firing Order
Next
From: John R Pierce
Date:
Subject: Re: Case sensitivity