PostgreSQL

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Integrate the PostgreSQL API with the Formatting API

Setup the PostgreSQL API trigger to run a workflow which integrates with the Formatting API. Pipedream's integration platform allows you to integrate PostgreSQL and Formatting remarkably fast. Free for developers.

[Data] Convert JSON to String with Formatting API on New Column from PostgreSQL API
PostgreSQL + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New or Updated Row from PostgreSQL API
PostgreSQL + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New Row Custom Query from PostgreSQL API
PostgreSQL + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New Row from PostgreSQL API
PostgreSQL + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New Table from PostgreSQL API
PostgreSQL + Formatting
 
Try it
New Column from the PostgreSQL API

Emit new event when a new column is added to a table. See Docs

 
Try it
New or Updated Row from the PostgreSQL API

Emit new event when a row is added or modified. See Docs

 
Try it
New Row from the PostgreSQL API

Emit new event when a new row is added to a table. See Docs

 
Try it
New Row Custom Query from the PostgreSQL API

Emit new event when new rows are returned from a custom query that you provide. See Docs

 
Try it
New Table from the PostgreSQL API

Emit new event when a new table is added to the database. See Docs

 
Try it
Delete Row(s) with the PostgreSQL API

Deletes a row or rows from a table. See Docs

 
Try it
[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

 
Try it
Execute Custom Query with the PostgreSQL API

Executes a custom query you provide. See Docs

 
Try it
[Data] Parse JSON with the Formatting API

Parse a JSON string

 
Try it
Find Row with the PostgreSQL API

Finds a row in a table via a lookup column. See Docs

 
Try it

Overview of PostgreSQL

Assuming you want a few paragraphs on what you can do with the PostgreSQL API:

The following examples demonstrate some of the things that can be done with the
PostgreSQL API:

  • Developing a custom storage engine for PostgreSQL
  • Adding a new data type to PostgreSQL
  • Creating a new function for PostgreSQL
  • Building a graphical user interface for PostgreSQL
  • And much more!

Connect PostgreSQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import pg from 'pg';

export default defineComponent({
  props: {
    postgresql: {
      type: "app",
      app: "postgresql",
    }
  },
  async run({steps, $}) {
    const { host, user, password, port, database, ca, cert, key } = this.postgresql.$auth;

    const sslConfig = ca && cert && key ? {
      ssl: {
        rejectUnauthorized: true, 
        ca,
        cert,
        key,
      },
    } : {};

    const clientConfig = {
      host,
      database,
      user,
      password,
      port,
      ...sslConfig, 
    };

    const client = new pg.Client(clientConfig);

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

    return results; 
  },
});

Connect Formatting

1
2
3
4
5
6
export default defineComponent({
  async run({ steps, $ }) {
    const text = ' Hello world! ';
    return text.trim()
  },
})