Action PostgreSQL
PostgreSQL Raw Execute
Executes any SQL string against PostgreSQL without parameter binding. Use for stored procedures, DDL, or database-specific syntax. Security note: Never pass user-controlled data directly into the SQL string — use PostgreSQL Execute for parameterized operations. Fires On Success with rows affected, or On Error with the error message.
Node IDPostgresRawExecuteAction
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 raw SQL to execute. No parameter binding is applied. Use only with trusted, non-user-controlled SQL strings. |
Require TLS require_tls | boolean | No | true | If true, requires a TLS/SSL connection to PostgreSQL. |
Include Executed SQL in Output include_executed_sql | boolean | No | false | If true, the executed SQL string is included in the output. Disable to avoid leaking SQL into downstream nodes or logs. |
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, and sql_executed if Include Executed SQL is enabled. |
On Error output1 | object | error | Fires on failure. Contains the error message. |