pg_update
Update database rows that match a WHERE clause. Requires explicit confirmation to prevent accidental modifications.
Instructions
Update rows matching a WHERE clause. Requires confirm=true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| set | Yes | JSON object of column-value pairs to update | |
| table | Yes | Table name | |
| where | Yes | WHERE clause (use $N for params) | |
| params | No | JSON array of parameter values for WHERE clause | |
| schema | No | Schema name (default: 'public') | |
| target | Yes | Target name from ~/.dbx/targets/ | |
| confirm | Yes | Must be 'true' to execute this destructive operation |