Skip to content

Postgres Trigger node#

Use the Postgres Trigger node to respond to events in Postgres and integrate Postgres with other applications. n8n has built-in support responding to insert, update, and delete events.

Credentials

You can find authentication information for this node here.

Examples and templates

For usage examples and templates to help you get started, refer to n8n's Postgres Trigger integrations page.

Events#

You can configure how the node listens for events.

  • Select Listen and Create Trigger Rule, then choose the events to listen for:
    • Insert
    • Update
    • Delete
  • Select Listen to Channel, then enter a channel name that the node should monitor.

Postgres event listener and required database permissions

  • To listen for trigger events, n8n automatically creates a Postgres trigger on the target table. This trigger is added when you activate a workflow, and removed when you deactivate it.
  • If your workflow is inactive, the trigger is also added when you test the workflow and removed once test event listening stops.
  • The Postgress trigger calls an automatically-created procedure to tell n8n about the event.
  • The user in your Postgres credential must have permissions to create and execute triggers and procedures. In PostgreSQL, this requires superuser access, table ownership, or the TRIGGER privilege - plus CREATE privilege on the schema where the procedure will reside.

n8n provides an app node for Postgres. You can find the node docs here.

View example workflows and related content on n8n's website.

This page was