PostgreSQL Case insensitive database/schema

Question

Is it possible to create a database or schema in PostgreSQL which is case insensitive?

Meaning below queries give me the same result.

Select * from "emp" where "name" = 'DEEpak' or Select * from "emp" where "name" = 'deepak'

I know I can achieve this by using query

Select * from "emp" where lower("name") = lower('deepak')

Laurenz Albe · Accepted Answer · 2018-08-07 09:45:25Z

1

As superuser

CREATE EXTENSION citext;

Now define all text columns of your tables as type citext.

This type does case insensitive string comparison.

answered Aug 7, 2018 at 9:45

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1