Duaer

Build

Read and write Postgres in Duaer

In Duaer, Postgres defaults to Operation Insert. Choose Schema and Table, then map fields in Columns. You need a postgres credential.

Insert a row

  1. Create a postgres credential.
  2. Search for Postgres, connect it after the previous node, and select that credential.
  3. Leave Operation on Insert.
  4. Choose Schema and Table.
  5. Map input fields to table columns in Columns. Select Execute step.

On the current default version you also get Select, Update, Insert or Update, Delete, and Execute Query (raw SQL with $1, $2 parameters).

If field names do not match column names, rename them first with Edit Fields.

See also Read and write MySQL in Duaer and Find documents with MongoDB in Duaer.

Questions

Can Postgres in Duaer run a raw SQL statement?

Yes. Set Operation to Execute Query and write SQL in Query. Prefer query parameters to reduce injection risk.

In this section

Nodes

Read and write MySQL in Duaer

In Duaer, MySQL defaults to Operation Insert. Choose Table. Data Mode defaults to Auto-Map Input Data to Columns. You need a mySql credential.

Nodes

Create an Airtable record in Duaer

In Duaer, Airtable defaults to Authentication Token and Resource Record; Operation defaults to Get. For create, switch to Create, pick Base and Table, then map Columns. You need an airtableTokenApi credential.

Data

Keep rows in a Duaer data table

In Duaer, a data table lives in the current project. Rows one digital organization writes can be read by another in the same project.