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.

Seamlessly integrate Postgres databases with Mazaal AI. Automate data workflows, enhance analytics, and streamline your database operations effortlessly.

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

@activepieces/piece-postgres

Postgres

Postgres - Database Integration - Mazaal AI Apps

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

Ready to Revolutionize Your Workflow?