Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] PostgreSQL case sensitivity - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] PostgreSQL case sensitivity
Date
Msg-id CAKFQuwZqBuhOJA0xREB-n_pjaRp8oF_Ay9yZXML6_hhXK-VbDA@mail.gmail.com
Whole thread Raw
In response to Re: [NOVICE] PostgreSQL case sensitivity  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-novice
Tree view
On Tue, Apr 25, 2017 at 4:17 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Rouzzi Anissa wrote:
> Please help me i would like to know if there is any way to disable the case sensitivity in
> PostgreSQL Server.
> How can i achieve that?

I guess you are speaking about string comparison.

You could use the "citext" type defined in the contrib module of that name:
https://www.postgresql.org/docs/current/static/citext.html

​If Albe has guessed wrong and you are speaking of identifiers, then no.

David J.​

pgsql-novice by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [NOVICE] PostgreSQL case sensitivity
Next
From: Pankaj Arora
Date:
Subject: [NOVICE] Change PostgreSQL Default Password Encryption