Skip to main content

​
Postgres

​
Run Query

Executes SQL against a database linked via the Postgres integration. Inputs
  • Postgres account.
  • Query — SQL editor (config). Use $1, $2, $3, … for bound parameters (never concatenate raw user input into SQL).
  • Parameters — Repeatable list of values; first parameter maps to $1, second to $2, etc. Leave empty for queries with no placeholders.
Outputs
  • rows — Repeatable: each item is one row as an object (column names → values). Suitable for SELECT results.
  • rowCount — Number of rows returned or affected (depending on the statement).
For INSERT/UPDATE/DELETE, you may get zero rows but a non-zero rowCount; design your workflow accordingly.