Update
PostgreSQL Plugin – Update
Summary (SEO Meta Description):
The PostgreSQL Update action in WeHub updates rows in a PostgreSQL table.
Supports column mapping, conditions, and schema-based validation for reliable workflow updates.
Overview
The Update action allows workflows to modify existing rows in a PostgreSQL table.
You can update one or multiple columns, apply conditions, and validate inputs against schemas.
This action is commonly used for updating records after transformations, syncing external systems, or managing transactional workflows.
Typical Use Cases:
- Update patient demographics in a clinical database
- Mark orders as completed after payment
- Modify user preferences or configurations
- Update workflow logs with new statuses
⚙️ Action: Update
Configuration Options:
| Field | Type | Description |
|---|---|---|
| Label | String | Custom name for the action. |
| Select Connection | Enum | Choose or create a PostgreSQL connection. |
| Table Name | Enum | Select the table to update rows in. |
| Columns | List | Define the columns and values to update. |
| Condition | String | SQL WHERE condition to filter which rows to update. |
| Inputs (Manual) | Mixed | Define input parameters manually with types (NUMBER, STRING, BOOLEAN, etc.). |
| Inputs Schema | Schema | Map input parameters using schema. |
| Query Inputs | Schema | Additional query input mapping for dynamic updates. |
FAQ
Q: Can I update multiple rows at once?
A: Yes. If the Condition matches multiple rows, all will be updated.
Q: What happens if no condition is set?
A: All rows in the table will be updated — use conditions carefully.
Q: Does this support schema validation?
A: Yes. You can enable Schema mapping to ensure inputs match expected types.
Keywords: WeHub PostgreSQL Plugin, PostgreSQL Update, Database Workflow Update, SQL Integration in WeHub