Query PostgreSQL on a schedule
•@dylburger•
•code:
•data:private•last updated:5 years ago
Build integrations remarkably fast!
You're viewing a public workflow template.
Sign up to customize, add steps, modify code and more.
Join 1,000,000+ developers using the Pipedream platform
steps.
trigger
Cron Scheduler
Deploy to configure a custom schedule
This workflow runs on Pipedream's servers and is triggered on a custom schedule.
steps.
run_sql_query
auth
to use OAuth tokens and API keys in code via the
auths objectcode
Write any Node.jscodeand use anynpm package. You can alsoexport datafor use in later steps via
return or this.key = 'value', pass input data to your code viaparams, and maintain state across executions with$checkpoint.async (event, steps) => {1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
}21
const { Client } = require('pg')
// The client will use environment variables to connect.
// See https://node-postgres.com/features/connecting.
//
// You'll need to add Pipedream environment variables
// for PGUSER, PGHOST, and PGPASSWORD at the very least.
// See https://docs.pipedream.com/environment-variables/
const client = new Client()
await client.connect()
// I run a mock query below, but you can replace that
// with any query you'd like
const { rows } = await client.query('SELECT NOW()')
for (row of rows) {
console.log(row)
}
await client.end()