postgres update rows from select code example
Example 1: update value postgresql
UPDATE table
SET column1 = value1,
column2 = value2 ,...
WHERE
condition;
Example 2: update record in postgreps
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
WHERE condition;