Postgres Pro
Downloads
Home   >   mailing lists

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

From jian he
Subject Re: postgresql database use a case insensitive collation
Date
Msg-id CACJufxFwv9TUHqwqc9c9WcD=toVsf7+vQFLHb=PZB+6M5w6mVQ@mail.gmail.com
Whole thread Raw
In response to postgresql database use a case insensitive collation  (Dennis <daslaner@gmail.com>)
List pgsql-admin
Tree view

Hi,
You cannot set database-wise case-insensitive collation. Since case insensitiveness is nondeterministic comparisons.

CREATE DATABASE ma page pg 15 quote
There is currently no option to use a database locale with nondeterministic comparisons (see CREATE COLLATION for an explanation). If this is needed, then per-column collations would need to be used.

You can also check: https://www.postgresql.org/docs/15/collation.html (section 24.2.2.4)


On Wed, May 25, 2022 at 11:49 AM Dennis <daslaner@gmail.com> wrote:
Hi,

How to make configuration my postgresql database use a case insensitive collation?

Dennis


--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


pgsql-admin by date:

Previous
From: Paul Smith
Date:
Subject: Re: postgresql database use a case insensitive collation
Next
From: Vivek Gadge
Date:
Subject: ERROR: found xmin 2706850882 from before relfrozenxid 126900049