PostgreSQL Event TriggerInstall

Summary

Listen for and emit workflow triggers based on event entries in a specified PostgreSQL event channel, polling the database at a configured interval.

Inputs

• Channel Key (required) — The unique identifier string for the PostgreSQL event channel to monitor for new events.
• Event Type (required) — The type of event to listen for; currently supports only 'httpExecutionCurl'.
• Poll Interval (Seconds) (required) — How often, in seconds, the node polls the PostgreSQL event channel for new events; minimum is 1 second.

Output shape

a single JSON object per event with fields: id, channelKey, eventType, command, createdAt (ISO string), and timeoutSeconds

The node polls the channel table for events with a 'sent' state, locks and updates events to a 'processing' state to prevent duplication, then emits events as JSON arrays. Polling continues until the workflow is stopped.