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