postgres case when is like 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