PostgreSQL UPDATE statement
In PostgreSQL, UPDATE statement is used to modify the existing records in a table. To update selected rows, you have to use WHERE clause otherwise all rows would be updated.
Following is the basic syntax of update statement:
See this example:
Consider a table named "EMPLOYEES" having the following data.
Follow the steps given below to update a table
Let's take an example:
Update ID, AGE and SALARY of the table "EMPLOYEES".
You can see that three columns have been updated: ID, AGE and SALARY.