New Column - Pipedream

import common from "../common.mjs"; export default { ...common, name: "New Column", key: "postgresql-new-column", description: "Emit new event when a new column is added to a table. [See the documentation](https://node-postgres.com/features/queries)", version: "2.0.8", type: "source", props: { ...common.props, schema: { propDefinition: [ common.props.postgresql, "schema", ], }, table: { propDefinition: [ common.props.postgresql, "table", (c) => ({ schema: c.schema, }), ], }, }, async run() { const previousColumns = this._getPreviousValues() || []; const columns = await this.postgresql.getColumns(this.table, this.schema); const newColumns = columns.filter((column) => !previousColumns.includes(column)); for (const column of newColumns) { const meta = this.generateMeta(column); this.$emit(column, meta); } this._setPreviousValues(columns); }, };

Label	Prop	Type	Description
PostgreSQL	`postgresql`	`app`	This component uses the PostgreSQL app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling Interval	`timer`	`$.interface.timer`	Pipedream will poll the API on this schedule
Schema	`schema`	`string`	Select a value from the drop down menu.
Table	`table`	`string`	Select a value from the drop down menu.

Label

Prop

Type

Description

PostgreSQL

postgresql

app

This component uses the PostgreSQL app.

N/A

db

$.service.db

This component uses $.service.db to maintain state between executions.

Polling Interval

timer

$.interface.timer

Pipedream will poll the API on this schedule

Schema

schema

string

Select a value from the drop down menu.

Table

table

string

Select a value from the drop down menu.

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.

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs

SSL Setup

Configure SSL on your PostgreSQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications

New Column from PostgreSQL API

Pipedream makes it easy to connect APIs for PostgreSQL and 2,800+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

Integrations#

Details#

Code#

Configuration#

Authentication#

Connecting to Restricted Databases

SSL Setup

About PostgreSQL#

More Ways to Use PostgreSQL#

Triggers#

Actions#

Explore Other Apps#

1
-
24
of
2,800+
apps by most popular

New Column from PostgreSQL API

Pipedream makes it easy to connect APIs for PostgreSQL and 2,800+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Connecting to Restricted Databases

SSL Setup

1-24of2,800+apps by most popular

1
-
24
of
2,800+
apps by most popular