> 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

Learn how to use the Postgres Trigger node in n8n. Follow technical documentation to integrate Postgres Trigger node into your workflows.

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**

Refer to the [Postgres credentials documentation](/integrations/builtin/credentials/postgres.md) for authentication information for this node.
{% 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. Refer to the [Postgres node documentation](/integrations/builtin/app-nodes/n8n-nodes-base.postgres.md) for more information.

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