postgresql Updating multiple columns in table


Example

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';