Postgres (AWS IAM) icon

Postgres (AWS IAM)

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

Actions6

Database → Update

AI-generated

Summary

Update rows in a Postgres table using AWS IAM authentication

Inputs

  • awsRegion (required) — AWS region where the RDS instance is located
  • endpoint (required) — RDS instance endpoint hostname
  • port (required) — Port number for the RDS connection
  • user (required) — Database user configured for IAM authentication
  • database (required) — Name of the database to connect to
  • schema (required) — Schema containing the target table
  • table (required) — Target table to update
  • dataMode — Data mapping mode: 'autoMapInputData' or 'defineBelow'
  • columnToMatchOn (required) — Column used to locate rows for update (e.g., primary key)
  • valueToMatchOn — Value to match against the selected column
  • valuesToSend — Collection of column-value pairs to set on matched rows
  • columns (required) — Columns mapper defining which columns to update

Output shape

A list of updated rows

The shape matches the selected output columns; may be empty if none are configured

Examples

Example 1: Update a product's name

Set awsRegion=us-east-1, endpoint=mydb.xxxxx.us-east-1.rds.amazonaws.com, port=5432, user=iam_user, database=appdb, table=products, columnToMatchOn=id, valueToMatchOn=42, valuesToSend column=name value="Widget", columns mapper includes name

Example 2: Batch update multiple rows

Enable Data Mode 'autoMapInputData', provide a list of valuesToSend for each column, and set Operation to Update with matching column=id and valuesToMatchOn from input items

Example 3: Update with explicit column mapping

Select Data Mode 'defineBelow', map specific incoming fields to target columns, specify columnToMatchOn='email', valueToMatchOn='user@example.com', and send values for updated columns

Links

Discussion