Question:
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?
Answer:
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%'