postgresql

UPDATE

Update all rows in a table

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

UPDATE person SET planet = 'Earth';

Update all rows meeting a condition

UPDATE person SET state = 'NY' WHERE city = 'New York';

Updating multiple columns in table

You can update multiple columns in a table in the same statement, separating col=val pairs with commas:

UPDATE person 
   SET country = 'USA', 
       state = 'NY' 
WHERE city = 'New York';

Updating a table based on joining another table

You can also update data in a table based on data from another table:

UPDATE person 
SET state_code = cities.state_code 
FROM cities
WHERE cities.city = city;

Here we are joining the person city column to the cities city column in order to get the city’s state code. This is then used to update the state_code column in the person table.


This modified text is an extract of the original Stack Overflow Documentation created by the contributors and released under CC BY-SA 3.0 This website is not affiliated with Stack Overflow