Skip to main content

Delete

PostgreSQL Plugin – Delete​

Summary (SEO Meta Description):
The PostgreSQL plugin in WeHub enables workflows to delete records from PostgreSQL databases.
Use the Delete action to remove rows from a table dynamically based on workflow conditions.

Overview​

The Delete Action in the PostgreSQL Plugin allows workflows to remove rows from a table.
It supports conditional deletions and integrates with WeHub schemas for structured data handling.

This action is useful for data cleanup, transaction rollbacks, and managing obsolete records directly inside workflows.

Typical Use Cases:

  • Remove expired session data
  • Delete patient or customer records by ID
  • Clean up temporary tables after processing
  • Enforce compliance by removing outdated records

⚙️ Action: Delete​

  • Description: Deletes rows from a PostgreSQL table.
  • Use Case: Remove records dynamically based on conditions passed from workflow data.

Configuration Options:

FieldTypeDescription
LabelStringCustom name for the action (e.g., "Delete Inactive Users").
Select ConnectionStringChoose an existing PostgreSQL connection or create a new one.
Table NameStringSelect the target table for deletion.
ConditionStringSQL-style condition to match records for deletion.
Inputs (Manual)EnumMap workflow inputs to condition values. Supports: NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY.
Truncate FieldsBooleanToggle to truncate long field values before execution.
SchemaSchemaSelect schema for validation and structured mapping.

FAQ​

Q: Can I delete multiple rows at once?
A: Yes. If the condition matches multiple rows, all will be deleted.

Q: What happens if no condition is set?
A: Without a condition, all rows in the table may be deleted. Always use conditions unless a full wipe is intentional.

Q: Can I use dynamic workflow inputs in conditions?
A: Yes. Use Manual Inputs to map workflow values into the delete condition.

Keywords: WeHub PostgreSQL Plugin, PostgreSQL Delete Action, Workflow Database Integration, Delete Records in PostgreSQL, SQL Data Management