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](../_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](../_images/postgresql__output.png)
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.