pg_query_prepared
Manage named prepared statements with PREPARE, EXECUTE, and DEALLOCATE operations. Note: deprecated due to session-local behavior and connection pool issues.
Instructions
[DEPRECATED] Manage named prepared statements: PREPARE, EXECUTE, DEALLOCATE. Prepared statements are session-local and unreliable with connection pools. Use parameterized pg_query instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | SQL query (required for prepare) | |
| name | Yes | Prepared statement name | |
| params | No | JSON array of parameters (for execute) | |
| target | Yes | Target name from ~/.dbx/targets/ | |
| action_type | Yes | Action to perform |