Transform all columns records to lowercase

Question

I'm using PostgreSQL 9.1 and I have a users table with a login column.

login names are case-sensitive, for example Bob, MikE, john. I would like to transform all these records into lowercase. How can I do that?

Answer 1

You can do this:

UPDATE TABLE SET column=lower(column)

Refer to www.postgresql.org/docs/9.1/static/functions-string.html