Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql database use a case insensitive collation - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: postgresql database use a case insensitive collation
Date
Msg-id 0ac62809-eb35-75f4-2fb6-c92cc590bff0@jakobs.com
Whole thread Raw
In response to postgresql database use a case insensitive collation  (Dennis <daslaner@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: postgresql database use a case insensitive collation
Next
From: Paul Smith
Date:
Subject: Re: postgresql database use a case insensitive collation