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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
2 years ago
11 months ago