Postgres Pro
Downloads
Home   >   mailing lists

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

From Albe Laurenz
Subject Re: [NOVICE] PostgreSQL case sensitivity
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53A2CB81@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to [NOVICE] PostgreSQL case sensitivity  (Rouzzi Anissa <rouzzi.anissa@gmail.com>)
Responses Re: [NOVICE] PostgreSQL case sensitivity  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Rouzzi Anissa
Date:
Subject: [NOVICE] PostgreSQL case sensitivity
Next
From: "David G. Johnston"
Date:
Subject: Re: [NOVICE] PostgreSQL case sensitivity