PostgreSQL

Connect it

Open Portal → Connections, choose Add, then PostgreSQL, and fill in its settings and its credential. The portal sends the one request every type uses, with "type": "postgresql". The credential goes in credential.secret; for this type it is the password.

The settings, the credential and a ready example body, from the public type catalog (no key needed):

GET https://api.docbutterfly.com/api/connection-types/postgresql
GET https://api.docbutterfly.com/api/connection-types/postgresql/schema

Operations

Each operation is an API call that names the connection. Reads bring data in from PostgreSQL; writes send data or files out to it.