PostgreSql Writer

PostgreSQL source is used to load data into PostgreSQL/Greenplum databases.

About PostgreSQL

PostgreSQL is an open-source, advanced relational database management system (RDBMS). It supports SQL and powerful features like complex queries, foreign keys, triggers, and full ACID compliance. It’s known for reliability, extensibility, and support for both structured and unstructured data.

Properties

Tip: To change Writer properties double click on it.

There are three ways of connecting to PostgreSql: Direct, Via SSL and Via SSH

**Important:** [Working with Date and Time fields](https://www.etl-tools.com/wiki/advanced-etl-processor/transforming-data/writer-targets/working-with-date-and-time-fields/)