Postgres
SQL commands targeting a Postgres database instance.
Types: postgres
Configuration
| 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 |