Connect with Zapier
Zapier is an automation platform that connects your work apps and does repetitive tasks for you. This example shows how to configure PostgreSQL® as a connection in zapier.
Variables
These are the placeholders you will need to replace in the code sample:
Variable | Description |
---|---|
HOSTNAME | Hostname for the PostgreSQL connection, from the service overview page |
PORT | Port for the PostgreSQL connection, from the service overview page |
DATABASE | Database Name for the PostgreSQL connection, from the service overview page |
SCHEMA | Default public schema or a specific schema |
USERNAME | Username for the PostgreSQL connection |
PASSWORD | Password for the above specified username |
Connect to PostgreSQL
- In skyvia workspace > Connections > Connector > PostgreSQL.
- In the General Tab give the connection a name, for example
MyDatabase
. - In the Connection tab, set:
- Host to
HOSTNAME
- Port: to
PORT
- Database to
DATABASE
- Schema to
SCHEMA
- Username to
USERNAME
- Password to
PASSWORD
- Host to
- Click Yes, Continue.