Postgres Pro
Downloads
Home   >   mailing lists

Thread: [NOVICE] PostgreSQL case sensitivity

[NOVICE] PostgreSQL case sensitivity

From
Rouzzi Anissa
Date:
Hello, 

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?
--

Cordialement

 ROUZZI Anissa 

Re: [NOVICE] PostgreSQL case sensitivity

From
Albe Laurenz
Date:
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

Yours,
Laurenz Albe

Re: [NOVICE] PostgreSQL case sensitivity

From
"David G. Johnston"
Date:
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.​