43

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?

Hannah Vernon
  • 70,041
  • 22
  • 171
  • 315
flyer88
  • 607
  • 2
  • 6
  • 7

1 Answers1

59

You can do this: 

UPDATE table_name SET column=lower(column)

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

Community
  • 1
kumar_2002
  • 956
  • 9
  • 12
  • 3
    And if you'd like to know how many rows were affected, a simple UPDATE table_name SET column = LOWER(column) WHERE column != LOWER(column); will do. – Fabien Snauwaert Mar 28 '18 at 13:38
  • I get this error HINT: No function matches the given name and argument types. You might need to add explicit type casts. while trying this. – Surya Oct 11 '19 at 07:13