The PostgreSQL UPDATE action is used to execute an update statement against a PostgreSQL database.
The input parameters for an update statement are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| query | String | Required | The query to execute against the database |
| metadata | JSON | Optional | The list of parameters to pass to the query |
The metadata parameter can be used to pass variables into the query parameter.
For example, if the contents of metadata are:
{
"type" : "mint"
}
This can be used in the query parameter as:
UPDATE flavors
SET flavor = {type}
WHERE flavor = "mint-choc";
Note: The { } are declared without quotations.
The output parameters from an update statement are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| result | Integer | Optional | The number of rows in the database that were affected by the statement |