Insert
PostgresSQL Plugin – Insert
Summary (SEO Meta Description):
The PostgresSQL Plugin Insert action allows workflows to insert new records into PostgreSQL tables.
Supports mapping workflow data to table columns with schema validation.
Overview
The Insert action of the PostgresSQL Plugin enables workflows to add new rows into a specified table.
It maps workflow inputs to database columns, ensuring structured data is inserted correctly.
This action is useful for persisting workflow outputs, storing transactions, or logging structured data directly into PostgreSQL.
⚙️ Configuration
| Field | Type | Description |
|---|---|---|
| Label | String | Custom name for the action node. |
| Select Connection | Connection | Choose or create a PostgreSQL connection. |
| Table Name | Dropdown | Select the target table where data will be inserted. |
| Columns | Key-Value | Define target column names and map workflow values. |
| Inputs (Manual) | Key-Value | Add manual input values with types. Supported: NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY. |
| Schema | Schema | Optional schema for validating the inserted record. |
💡 Typical Use Cases
- Insert patient data into a healthcare database.
- Store workflow logs or job results for auditing.
- Add new customer records in CRM-related workflows.
- Save IoT events or telemetry data into structured tables.
FAQ
Q: Can I insert into multiple tables at once?
A: No. Each Insert action targets a single table. Use multiple nodes for multi-table inserts.
Q: What happens if a required column is missing?
A: PostgreSQL will throw an error. Ensure all required fields are mapped.
Q: Does schema validation run before insert?
A: Yes. If a schema is provided, data is validated before being sent to PostgreSQL.
Keywords: WeHub PostgreSQL Plugin, Insert Action, Database Integration, Insert Row PostgreSQL, Workflow Database Insert