postgresql – Turn off case sensitive on Postgres


When I do the command select * from tabela where name like '%teste%' the line with the name TesTe returns, but the same doesn't happen in postgres, I don't want to put lower(name) to work, how can I disable the case sensitive in a column?


To perform a search on Postgres, disregarding capital or lowercase letters, just change like to ilike

Your search looks like this:

select * from tabela where name ilike '%teste%'
Scroll to Top