Skip to main content

PostgreSqlGetCollection

This activity retrieves a collection of records from a PostgreSQL database based on a specified SQL query.

Core Functions​

  • Accepts a SQL query as input
  • Sends the query to the connected PostgreSQL database
  • Retrieves multiple records from the database
  • Returns the result as a collection of rows

Inputs​

  • Query: Represents the SQL query used to retrieve multiple records from the PostgreSQL database
    Type: String

Outputs​

  • Output: Returns the collection of records retrieved from the database
    Type: DataTable

Short Technical Summary​

A database operation activity that executes a SQL query on a connected PostgreSQL database and retrieves multiple records, returning the result as a DataTable collection.