UPDATE Query in PostgreSQL

PostgreSQL UPDATE To update the existing records in a table one can use the UI or can use the PostgreSQL UPDATE statement.

Syntax:

UPDATE table_name
SET column_1 = expr_1,  
    column_2 = expr_2,  
    ...  
    column_n = expr_n  
WHERE conditions;  

UPDATE statement using UI: Other than Query tool, we can also UPDATE statement in PostgreSQL using UI. To UPDATE statement using UI in PostgreSQL, follow the below steps.

• Right-click on the selected table.
• Move your cursor over the option scripts.
• Click on the “UPDATE script” option.
• Put the values on the place of “?”.
• Fulfill the WHERE condition.
• Click on the “play” button.

Example 1: Updating a single column of a table. Employment table before update:

UPDATE “EMPLOYMENT”    
SET “RATE” = 85 
WHERE “ID” = 3;

Explanation: The RATE will be updated to 85 where ID is 3.

Employment table after update will be like this:

Example 2: Updating multiple columns of a table. Employment table before update:

UPDATE “EMPLOYMENT”    
SET “RATE” = 85, “STATE” = ‘F’
WHERE “ID” = 3;

Explanation: The RATE will be updated to 85 and STATE will be updated to ‘F’ where ID is 3.

Employment table after update will be like this:

Please follow and like us: