UPDATE my_table SET my_column = UPPER(my_column)
UPDATE my_table SET my_column = UPPER(my_column)
SELECT upper('Hello World'); -- HELLO WORLD
SELECT lower('Hello World'); -- hello world
SELECT upper('Hello World'); -- HELLO WORLD
SELECT lower('Hello World'); -- hello world