Postgres (AWS IAM) icon

Postgres (AWS IAM)

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

Actions6

Database → Insert

AI-generated

Summary

Insert rows into a PostgreSQL table using AWS IAM authentication.

Inputs

  • Main (required) — Items from previous node; each item's JSON data is mapped to table columns.

Output shape

Main

Returns execution results; with 'single' batching combined results, with 'independently' one result per input item, with 'transaction' all-or-nothing. Emits success or error items based on continueOnFail. Empty item JSON triggers INSERT INTO ... DEFAULT VALUES.

Examples

Example 1: Auto-map insert

Set dataMode to 'autoMapInputData'; ensure incoming item property names match table column names.

Example 2: Manual column insert

Set dataMode to 'defineBelow'; use 'Values to Send' fixedCollection or 'Columns' resource mapper to specify column-value mappings.

Links

Discussion