PostgreSQL ILIKE Operator can be used instead of LIKE to make the match case-insensitive according to the active locale. ILIKE is same as LIKE operator except case-insensitive operation.
Using LIKE Operator.
1. Find the employees whose name starts with a
select * from emp where ename LIKE 'a%';
Output:
Using ILIKE operator
2. Find the employees whose name starts with a
select * from emp where ename ILIKE 'a%';
Output: