Case-Insensitive Search in PostgreSQL

Deepak Mahto performs a search:

Case-insensitive search is one of the most common issues I encounter when helping customers migrate from Oracle or SQL Server to PostgreSQL. Unlike Oracle (with NLS_SORT) or SQL Server (with case-insensitive collations), PostgreSQL does not natively support case-insensitive search.

Read on for a few workarounds, including one that Deepak recommends never using.