# PostgreSQL

[PostgreSQL](https://www.postgresql.org/) can either be used as a data
source or a data destination in Zuar Runner. Zuar Runner's own internal database
is PostgreSQL.

.. image:: assets/postgresql-1.png

Source plugin example: [Query](/jobs/query/)

Destination plugin examples: [CSV](/jobs/csv/),
[Salesforce](/connectors/salesforce/),
[SQL](/jobs/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](/databases/database-urls/)
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](/jobs/csv/) job:

.. image:: assets/postgresql__output.png
   :alt: 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](/jobs/sql/) statements to a PostgreSQL
database. Use PostgreSQL syntax in these Zuar Runner SQL jobs.