PostgreSQL

PostgreSQL Help & Support

What PostgreSQL Triggers and Actions are Supported?

Supported Triggers#

  • New or Updated Row - Triggered when a new row is added or modified.
  • New Column - Triggered when you add a new column.
  • New Row (Custom Query) - Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
  • New Table - Triggered when you add a new table.
  • New Row - Triggered when you add a new row.

Supported Actions#

  • Update Row - Updates an existing row.
  • New Row - Adds a new row.

Supported Searches#

  • Find Row via Custom Query - Finds a row in a table via a custom query you control.
  • Find Row - Finds a row in a table via a lookup column.

How to Get Started with PostgreSQL

The hardest part of connecting to PostgreSQL is getting the connection settings right. When connecting a new PostgreSQL account these are the fields you are presented with:

Connect Fields

Host The IP address or hostname (db.example.com) of where your database instance resides. Make sure it is accessible from outside your network. We send out database connections from the IP addresses listed here.

Port 5432 is the default for PostgreSQL. Change if you run on a different port

Database Name of the database to read data out of.

Schema The schema inside PostgreSQL to search for tables.

Username Username with access to the database. We recommend creating a brand new Zapier-specific user with highly limited permission scope.

Password Similar to the username, make this a unique strong password (check out https://random.org). This password should not contain spaces.

Note: all fields are stored encrypted in our database. Of course, we have the encryption keys on hand but they are stored separately to minimize risk. Nonetheless, we recommend not hooking a production database to Zapier. Instead, set up an intermediary database to connect with Zapier then dump data back to your main production database using some out-of-band process.

Need More Help? - Our support team is happy to help -- send us a message

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn More

Getting Started with Zapier

Need more help? Try the Zapier Help Center