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
Your search looks like this:
select * from tabela where name ilike '%teste%'