Postgres
SQL commands targeting a Postgres database
instance.
Types:
postgresConfiguration
Name | Required | Description |
PG_HOST | yes | The Postgres database hostname. No formatting or port numbers, just
the hostname. |
PG_DB | yes | The name of the Postgres database |
PG_USER | yes | The database username |
PG_PASS | yes | The database password |
PG_PORT | no | Defaults to 5432 |
FIELD_SEPARATOR | no | Defaults to tab for postgres and to
, for postgres-csv |
PGSSLMODE | no | Defaults to prefer |
PGSSLKEY | no | SSL certificate in PEM format encoded as base64 |
PGSSLCERT | no | SSL certificate in PEM format encoded as base64 |
PGSSLROOTCERT | no | SSL certificate authority (CA) in PEM format encoded as base64 |