PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site
Explore
/
Apps
/
PostgreSQL

PostgreSQL API Integrations

Build and run workflows using the PostgreSQL API. Use 1000s of open source triggers and actions across 500+ apps. Or write custom code to integrate any app or API in seconds.

const { Client } = require('pg')

const { host, user, password, port, database } = auths.postgresql

const client = new Client({
  host,
  database,
  user,
  password,
  port,
})

await client.connect()
this.results = (await client.query("SELECT NOW()")).rows
await client.end()

Authentication

PostgreSQL uses API keys for authentication. When you connect your PostgreSQL account, Pipedream securely stores the keys so you can easily authenticate to PostgreSQL APIs in both code and no-code steps.