MOCKSTACKS
EN
Questions And Answers

More Tutorials









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.

Conclusion

In this page (written and validated by ) you learned about postgreSQL UPDATE . What's Next? If you are interested in completing postgreSQL tutorial, your next topic will be learning about: postgreSQL Window Functions.



Incorrect info or code snippet? We take very seriously the accuracy of the information provided on our website. We also make sure to test all snippets and examples provided for each section. If you find any incorrect information, please send us an email about the issue: mockstacks@gmail.com.


Share On:


Mockstacks was launched to help beginners learn programming languages; the site is optimized with no Ads as, Ads might slow down the performance. We also don't track any personal information; we also don't collect any kind of data unless the user provided us a corrected information. Almost all examples have been tested. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. By using Mockstacks.com, you agree to have read and accepted our terms of use, cookies and privacy policy.