run-query

A string indicating the name of the client application connecting to the server.

An integer indicating the maximum number of milliseconds to wait for a connection to be established before timing out.


      **DO NOT** insert dynamic input directly into the query string. Instead, use $1, $2, $3 and add them in args for parameterized queries to prevent **SQL injection.**

Please use $1, $2, etc. for parameterized queries to avoid SQL injection.

An integer indicating the maximum number of milliseconds to wait for a query to complete before timing out.

The CA certificate to use for verification of server certificate.

A string indicating the name of the database to connect to.

Connect to the postgres database over SSL

 A string indicating the hostname of the PostgreSQL server to connect to.

A string indicating the password to use for authentication.

An integer indicating the port of the PostgreSQL server to connect to.

Verify the server certificate against trusted CAs or a CA provided in the certificate field below. This will fail if the database server is using a self signed certificate.

A string indicating the user to authenticate as when connecting to the PostgreSQL server.

The world's most advanced open-source relational database

postgres

Postgres

new-row

**NOTE:** The trigger fetches the latest rows using the provided order by column (newest first), and then will keep polling until the previous last row is reached.

Use something like a created timestamp or an auto-incrementing ID.

The direction to sort by such that the newest rows are fetched first.

Postgres integration

Overview

Triggers

New Row

Actions

Run Query