We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

**Highly recommended!** Usually you want the results to be most recent first so we can skim off only new results, so choose something like `date_created` or your autoincrement `id`. Column names that contain a space must be enclosed within brackets `[ ]`.

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.

Query results must have a unique `id` field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

**Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows**

Usually something auto-incremented like `id`. Must be unique. Column names that contain a space must be enclosed within brackets `[ ]`.

Usually something like `date_updated` or `last_modified`. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

You should include desired ordering and limiting in the query.

**This query must run in less than ~30 seconds.**

You should include desired ordering and limiting (usually to 1 record) in the query.

**This query must run in less than ~30 seconds.**

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.

PostgreSQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

Amazon Relational Database Services (RDS) allow you to set up, operate, and scale relational databases in the cloud.

Amazon Relational Database Services (RDS)

The name of one or more comma delimited channels that the event will be triggered upon.

The name of the event to be triggered on the channel or channels.

The event data payload/message associated with the event to be triggered on the channels.

If no values are supplied then the entire payload of a Zapier trigger will be delivered. Please note that there is a 10kb limit on the data that can be sent to only do this if you are sure the data payload size will be below this limit.

Pusher is an evented pub/sub platform that lets you push real-time messages to web, mobile and IoT applications.

Pusher

Clearly see activity from your PostgreSQL database with this Zapier automation which triggers an event every time a new row is added. Pusher will pass the information to your web and mobile apps in realtime. 

Zapier triggers an event and sends it to your app through Pusher

PostgreSQL + Pusher

Publish Pusher events for new PostgreSQL rows

New Column

New Row (Custom Query)

New or Updated Row

Trigger Column

Update Row

Find Multiple Rows via Custom Query

Publish Pusher Event

Event Data

New Row

Order By

Dedupe Key

New Table

New Row

Find Row

Find Row via Custom Query

About PostgreSQL

Related categories

Similar apps

MySQL

SQL Server

Amazon Relational Database Services (RDS)

About Pusher

Related categories