Re: postgresql database use a case insensitive collation

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Dennis <daslaner(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql database use a case insensitive collation
Date: 2022-05-25 06:39:25
Message-ID: 4225123ef7e892c550452c22257282ff0755ff09.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2022-05-25 at 09:19 +0300, Dennis wrote:
> How to make configuration my postgresql database use a case insensitive collation?

You'd have to define such a collation with CREATE COLLATION and you have to use it
in column definitions explicitly, since such a collation cannot be used as database
collation.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2022-05-25 07:33:32 Re: postgresql database use a case insensitive collation
Previous Message Dennis 2022-05-25 06:19:23 postgresql database use a case insensitive collation