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 (seeCREATE COLLATIONfor 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@xxxxxxxxx> 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
