Action PostgreSQL
PostgreSQL Execute
Executes an INSERT, UPDATE, or DELETE statement against PostgreSQL. Returns rows affected. Use $1, $2, ... parameters to prevent SQL injection. Fires On Success with rows affected, or On Error with the error message.
Node IDPostgresExecuteAction
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Connection String Secret Key connection_string_secret_key | string | No | POSTGRES_URL | Key in the Secrets store holding your PostgreSQL connection string. |
SQL Statement sql | textarea | Yes | — | The INSERT, UPDATE, or DELETE statement to execute. Use $1, $2, ... for parameterized queries. |
Parameters (JSON Array) parameters | textarea | No | — | Optional JSON array of parameter values matching $1, $2, ... placeholders. E.g. ["val1", 42]. |
Require TLS require_tls | boolean | No | true | If true, requires a TLS/SSL connection to PostgreSQL. |
Timeout (seconds) timeout_seconds | integer | No | 30 | Connection timeout in seconds. |
Inputs
| Input | Type | Required | Description |
|---|---|---|---|
Execute input0 | object | Yes | Execution signal. |
Outputs
| Output | Type | Identifier | Description |
|---|---|---|---|
On Success output0 | object | result | Fires on successful execution. Contains rows_affected. |
On Error output1 | object | error | Fires on failure. Contains the error message. |