PostgreSQL UPDATE Keyword

The PostgreSQL UPDATE keyword is used to modify the existing records in a table. A PostgreSQL WHERE clause can be used with the UPDATE statement to update the selected rows, otherwise all the rows will be assigned the updated value.

Syntax

The syntax for using UPDATE keyword in PostgreSQL is given below:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition(s);

Example:

Consider a database containing a table called Employee with the following records:

• To update the City and Salary of an employee whose EmpID is 5, the statement will be:

  UPDATE Employee
  SET City = 'Mumbai', Salary = 2900
  WHERE EmpID = 5;
  
  --See the result
  SELECT * FROM Employee
  

  
  

  Now the Employee table will contain following records:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3000
  2	Marry	New York	24	2750
  3	Jo	Paris	27	2800
  4	Kim	Amsterdam	30	3100
  5	Ramesh	Mumbai	28	2900
  6	Huang	Beijing	28	2800

• Similarly, to update the Salary of John who lives in London, the following statement can be used:

  UPDATE Employee
  SET Salary = 3200
  WHERE Name = 'John' AND City = 'London';
  
  --see the update
  SELECT * from Employee;
  

  
  

  Now the Employee table will contain following records:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3200
  2	Marry	New York	24	2750
  3	Jo	Paris	27	2800
  4	Kim	Amsterdam	30	3100
  5	Ramesh	Mumbai	28	3000
  6	Huang	Beijing	28	2800