PostgreSQL

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

../_images/postgresql-1.png

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:

postgresql://<username>:<password>@<hostname>/<database>

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

postgresql://mitto:<password>@db/analytics

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

CSV to Postgres

Note

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

SQL

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