PostgreSQL - UPDATE

In PostgreSQL, UPDATE statement is used to modify or change the existing records in a table. You can use WHERE clause with UPDATE statement to update the selected rows. Otherwise, all the rows would be updated.

In this tutorial, we will learn how to update the specific data in one or more columns or rows in a table.

Syntax

Following is the syntax of UPDATE statement with WHERE clause is as follows −

UPDATE table_name
SET column1 = value1, column2 = value2, ..., columnN = valueN
WHERE [condition];

Here,

• You can combine N number of conditions using AND or OR operators.

Example of PostgreSQL UPDATE Statement

Consider the table COMPANY, having records as follows −

testdb# select * from COMPANY;

In this example, we are updating ADDRESS for a customer, whose ID is 3 −

testdb=# UPDATE COMPANY SET SALARY = 15000 WHERE ID = 3;

Now, COMPANY table would have the following records −

Previously, ID 3 salary was 20000. Now it's 15000.

If you want to modify all ADDRESS and SALARY column values in COMPANY table, you do not need to use WHERE clause and UPDATE query would be as follows −

testdb=# UPDATE COMPANY SET ADDRESS = 'Texas', SALARY=20000;

Now, COMPANY table will have the following records −