Try
update table_name
set column_name = lower(column_name);

HTH

David.