Postgres (AWS IAM) icon

Postgres (AWS IAM)

Get, add and update data in Postgres via AWS RDS IAM authentication

Actions6

Database → Select

AI-generated

Summary

Select rows from a PostgreSQL table using AWS IAM authentication.

Inputs

  • awsRegion (required) — The AWS region where the RDS instance is located
  • endpoint (required) — The RDS instance endpoint hostname
  • port (required) — The port number of the RDS instance
  • user (required) — The database user configured for IAM authentication
  • database (required) — The name of the database to connect to
  • schema (required) — The schema that contains the table you want to work on
  • table (required) — The table you want to work on
  • returnAll — Whether to return all results or only up to a given limit
  • limit — Max number of results to return
  • where — Condition(s) to filter rows
  • combineConditions — How to combine the conditions defined in "Select Rows": AND requires all conditions to be true, OR requires at least one condition to be true
  • sort — Sort rule(s) applied to the result set
  • options — Execution options such as query batching, output columns, and other query settings

Output shape

A list of result rows

May be empty; output columns can be configured; when limit is set only that many rows are returned; returnAll true returns all rows; results are returned as items in the workflow.

Examples

Example 1: Select all rows from a table with default pagination

Configure required connection details (awsRegion, endpoint, port, user, database, schema, table); leave where empty; set returnAll false and limit 50 to fetch up to 50 rows.

Example 2: Select rows with a filter and sorting

Set connection details; add a where condition (e.g., column 'status' equal to 'active'); use combineConditions AND; add a sort rule on 'created_at' DESC; optionally adjust limit.

Links

Discussion