Action PostgreSQL

PostgreSQL Query

Executes a SELECT query against PostgreSQL. Returns rows as a JSON array. Use $1, $2, ... placeholders to prevent SQL injection. Fires On Success with the rows, or On Error with the error message.

Node IDPostgresQueryAction

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 (e.g. postgresql://user:pass@host/db).
SQL Query `sql`	`textarea`	Yes	—	The SELECT query 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 query. Contains rows (JSON array) and row_count.
On Error `output1`	`object`	`error`	Fires on failure. Contains the error message.