Re: PostgreSQL case sensitivity

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Rouzzi Anissa *EXTERN*'" <rouzzi(dot)anissa(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: PostgreSQL case sensitivity
Date: 2017-04-25 11:17:36
Message-ID: A737B7A37273E048B164557ADEF4A58B53A2CB81@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2017-04-25 14:26:41 Re: PostgreSQL case sensitivity
Previous Message Rouzzi Anissa 2017-04-25 09:17:29 PostgreSQL case sensitivity