PostgreSQL update all value to upper case for one column

Question

I have a table : Customer and column = [name,surname,language]

I want to update all language columns value to upper case how can I do it?

I have seen upper() method but it used on select operations. I need to update.

Answer 1

It's a bit unclear what exactly you mean, but it sounds as if you are looking for:

update customer
   set language = upper(language);

This will update the column language to upper case for all rows in the table customer.