PostgreSQL can either be used as a data source or a data destination in Zuar Runner. Zuar Runner’s own internal database is PostgreSQL.


Source plugin example: Query

Destination plugin examples: CSV, Salesforce, SQL

PostgreSQL as a Data Destination

  • Zuar Runner automatically creates the PostgreSQL database schema if it doesn’t exist

  • Zuar Runner automatically creates the PostgreSQL database tables if they don’t exist

  • Zuar Runner automatically determines data types for PostgreSQL columns

  • Zuar Runner automatically adds new columns to PostgreSQL tables based on new fields in source systems

  • Zuar Runner automatically adjusts PostgreSQL tables based on changes in source data

PostgreSQL Specific Setup

Below is the database url structure for connecting to a PostgreSQL database:


When using Zuar Runner’s internal PostgreSQL database as a destination, the database url structure is:


Here’s an example of using a PostgreSQL database as a destination in a CSV job:

CSV to Postgres


When outputting to a PostgreSQL database, leaving the “Schema” blank will create a table in the public schema.


Zuar Runner can send SQL statements to a PostgreSQL database. Use PostgreSQL syntax in these Zuar Runner SQL jobs.