case insensitive approach using like in psql code example Example: postgres like case insensitive using ILIKE instead of LIKE