postgresql 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 = 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.