Re: postgresql database use a case insensitive collation

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql database use a case insensitive collation
Date: 2022-05-25 07:33:32
Message-ID: 0ac62809-eb35-75f4-2fb6-c92cc590bff0@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Smith 2022-05-25 08:43:03 Re: postgresql database use a case insensitive collation
Previous Message Laurenz Albe 2022-05-25 06:39:25 Re: postgresql database use a case insensitive collation