Re: Case Insensitive

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Case Insensitive
Date: 2019-03-28 09:24:58
Message-ID: 2049082d-3d29-c012-bffa-0bb6f2779a19@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 2019-03-28 09:20, Sridhar N Bamandlapally wrote:
> Can we achieve CASE INSENSITIVE in PostgreSQL?

Use the citext extension.

In PostgreSQL 12, there will be support for case-insensitive collations.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Atkins 2019-03-28 09:30:21 Re: Case Insensitive
Previous Message Ron 2019-03-28 09:08:48 Re: Case Insensitive

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2019-03-28 09:30:21 Re: Case Insensitive
Previous Message Ron 2019-03-28 09:08:48 Re: Case Insensitive