Postgres (AWS IAM) icon

Postgres (AWS IAM)

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

Actions6

Database → Insert or Update

AI-generated

Summary

Insert or update rows in a PostgreSQL table using AWS IAM authentication

Inputs

  • awsRegion (required) — AWS region of the RDS instance
  • endpoint (required) — RDS instance endpoint hostname
  • port (required) — Port number (default 5432)
  • user (required) — Database user name for IAM authentication
  • database (required) — Database name (resource locator)
  • schema (required) — Schema containing the target table
  • table (required) — Target table (resource locator)
  • dataMode — Mapping mode; 'autoMapInputData' uses input field names matching columns, 'defineBelow' lets you specify columns manually
  • columnToMatchOn (required) — Column used to match rows for updates; must be unique
  • valueToMatchOn — Value to compare against the unique column for updates
  • valuesToSend — Define per‑column values when using manual mapping mode
  • columns (required) — Mapper to specify which input fields map to which table columns
  • options — Additional query options such as query batching, output columns, and conflict handling

Output shape

An array of items, each representing the row that was inserted or updated

The shape may be empty if no rows match for an update or if query batching is used; pagination or error handling is controlled by node options

Examples

Example 1: Add a new customer or update an existing one based on the customer_id

Set AWS Region, Endpoint, Port, User, Database, Table; choose Data Mode 'autoMapInputData'; select Unique Column 'id'; provide Value of Unique Column; map input fields to Columns; enable desired Options

Example 2: Bulk upsert a list of product records, returning the inserted/updated rows

Configure connection parameters; enable Query Batching 'single'; set Output Columns as needed; use ValuesToSend to define column values; specify Unique Column 'sku'

Links

Discussion