postgres set column equal to another 1

postgres set column equal to another

UPDATE table_name 
SET column_one = column_two,
WHERE column_two = 'some string'

Here is what the above code is Doing:
1. We’re selecting the table we want to update.
2. We’re setting the value of column_one to the value of column_two.
3. We’re specifying the row we want to update by using the WHERE clause.

Similar Posts