pgsql like case insensitive code example
Example 1: postgres like case insensitive
using ILIKE instead of LIKE
Example 2: postgresql like case-insensitive
-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john