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.