Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: postgresql database use a case insensitive collation
Date
Msg-id 4225123ef7e892c550452c22257282ff0755ff09.camel@cybertec.at
Whole thread Raw
In response to postgresql database use a case insensitive collation  (Dennis <daslaner@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Dennis
Date:
Subject: postgresql database use a case insensitive collation
Next
From: Holger Jakobs
Date:
Subject: Re: postgresql database use a case insensitive collation