The UPDATE statement updates rows in a table.

Synopsis

UPDATE relation_expr AS name SET qualified_name = a_expr DEFAULT ( qualified_name_list ) = ( a_expr DEFAULT , ) select_with_parens , WHERE a_expr RETURNING target_list

Required Privileges

The user must have the SELECT and UPDATE privileges on the table.

Parameters

Parameter Description
   


Yes No