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