> For the complete documentation index, see [llms.txt](https://docs.n8n.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.n8n.io/integrations/builtin/trigger-nodes/n8n-nodes-base.postgrestrigger.md).

# Postgres Trigger

Use the Postgres Trigger node to respond to events in [Postgres](https://www.postgresql.org/) and integrate Postgres with other applications. n8n has built-in support responding to insert, update, and delete events.

{% hint style="info" %}
**Credentials**

You can find authentication information for this node [here](/integrations/builtin/credentials/postgres.md).
{% endhint %}

{% hint style="info" %}
**Examples and templates**

For usage examples and templates to help you get started, refer to n8n's [Postgres Trigger integrations](https://n8n.io/integrations/postgres-trigger/) page.
{% endhint %}

## Events <a href="#events" id="events"></a>

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.

{% hint style="info" %}
**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 publish a workflow, and removed when you unpublish it.
* If your workflow isn't published, 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.
  {% endhint %}

## Related resources <a href="#related-resources" id="related-resources"></a>

n8n provides an app node for Postgres. You can find the node docs [here](/integrations/builtin/app-nodes/n8n-nodes-base.postgres.md).

View [example workflows and related content](https://n8n.io/integrations/postgres-trigger/) on n8n's website.