pg_delete
Delete rows from a PostgreSQL table matching a WHERE clause. Requires a confirmation flag to prevent accidental deletions.
Instructions
Delete rows matching a WHERE clause. Requires confirm=true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| 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 |