Re: postgresql database use a case insensitive collation

[Holger Jakobs <holger@xxxxxxxxxx>]

Am 25.05.22 um 08:19 schrieb Dennis:
> Hi,
>
> How to make configuration my postgresql database use a case 
> insensitive collation?
>
> Dennis

Hi Dennis,

you may use the data type citext (case insensitive text). It's not 
builtin, but an extension, which has to be activated in every database with

CREATE EXTENSION citext;

Regards,

Holger


--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Attachment: OpenPGP_signature
Description: OpenPGP digital signature