copy value from one column to another sql code example

Example 1: copy all values of a column to another column in sql in same table

UPDATE table SET columnB = columnA;

Example 2: copy value from one column to another postgres

UPDATE table SET columnB = columnA;