Skip to main content

PostgreSQL

Query a PostgreSQL database. PostgreSQL node in ActionFlows. Inputs, outputs, and how to use it.

PostgreSQL

Overview

Query a PostgreSQL database.

Requirements

Credential Required

This node likely requires an integration credential. Add the related API key/secret from Integrations before execution.

Inputs

Standard Inputs

  • Parametersjson · optional

    Array of parameters for prepared SQL statements

    Required
    No
    Multiple
    No
  • Querytextarea · required

    SQL query to execute against the PostgreSQL database

    Required
    Yes
    Multiple
    No
  • Timeout (seconds)number · optional

    Maximum time to wait for query execution

    Required
    No
    Multiple
    No
    Default
    30
    Constraints
    min: 1 · max: 300 · step: 1 (seconds)

Outputs

  • Execution Timenumber

    Query execution time in milliseconds

  • Resultjson

    Query results as JSON array

  • Row Countnumber

    Number of rows returned by the query