Tool
Upsert row
The PostgreSQL Upsert Row tool enables seamless insertion or updating of rows within your PostgreSQL database. It intelligently adds new rows or updates existing ones based on conflict targets, ensuring your data remains accurate and up-to-date.
Features
- Supports both inserting new rows and updating existing rows in one operation
- Utilizes conflict target column to identify and resolve insert conflicts by updating existing data
- Accepts JSON object for flexible row value input, allowing dynamic database operations
- Compatible with any PostgreSQL table and schema specified by the user
- Easy integration with Pipedream workflows for automated database management
Benefits
- Streamlines data management by combining insert and update functions to reduce redundant queries
- Prevents duplicate data by automatically handling conflicts through upsert logic
- Enhances database consistency and integrity with precise conflict resolution
- Saves development time by simplifying code and automating database row operations
- Supports scalable and efficient data workflows, ideal for real-time applications
Description
Adds a new row or updates an existing row. See the documentation
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| schemarequired | string | Database schema |
| tablerequired | string | Database table |
| conflictTargetrequired | string | If insert fails, update the row with the same value in this column. |
| rowValuesrequired | object | JSON representation of your table row values. For example: |