UPDATE table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ]
Use this parameter to specify the name of an existing table to update.
Use this parameter to specify the name of a column to update in the table you specified.
This parameter takes the expression or value that you want assigned to the specified column.
A PostgreSQL extension of the UPDATE command is the ability to use column values from other tables within the WHERE condition; to do this correctly, you must use this parameter to list the tables you will be pulling column values from.
Use this parameter to state the WHERE condition for UPDATE to use. This can be any valid expression.
Use the UPDATE command to modify column values of all rows that match your WHERE condition. You can also use this command to update the values of array columns, including single elements, a range, or the entire array. To update only the table specified, pass the >ONLY parameter, otherwise all sub-tables will be updated as well.
Permissions | |
---|---|
You must have write access to any columns you are attempting to modify, and read access to any columns referenced within your WHERE statement. |