The target-postgres Singer target sends data into PostgreSQL database after it was pulled from a source using a Singer tap.

Alternative variants

Multiple variants of target-postgres are available. This document describes the meltano variant.

Alternative variants are:

Standalone usage

Install the package using pip:

pip install git+https://github.com/meltano/target-postgres.git

For additional instructions, refer to the README in the repository.

Usage with Meltano

Install Meltano, create your Meltano project, and add the target to your project as a loader:

meltano add loader target-postgres --variant meltano

For additional instructions, refer to the Meltano-specific documentation for target-postgres.

Capabilities

Settings

user

password

host

port

Database Name (dbname)

URL (url)

Lets you set user, password, host, port, and dbname in one go using a postgresql:// URI. Takes precedence over the other settings when set.

schema

Looking for help?

If you're having trouble getting target-postgres to work by itself or with Meltano, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page?

This page is generated from a YAML file that you can contribute changes to! It is also validated against a JSON Schema used for taps and targets.