postgresql Update all rows in a table


Example

You update all rows in table by simply providing a column_name = value:

UPDATE person SET planet = 'Earth';