UPDATE STATEMENT

Pupose

Use the UPDATE statement to update new rows into a table. The PSQL update statement is identical to the SQL update statement followed by a semicolon.

Syntax

<psql_update_stmt> ::=
<update_stmt> ;

Element

Description

update_stmt

Semantics

See the SQL Reference Manual for a description of the update statement.

Examples

The below is an example of a valid UPDATE statement in PSQL:

   UPDATE table1 SET salary = :new_sal WHERE id = :emp_id;

See also

DELETE, INSERT and SELECT