Transform all columns records to lowercase 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?
You can do this:   

UPDATE table_name SET column=lower(column)


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