FlowDSL Node Catalog

Postgres Query

Run SELECT and emit rows on `items`.

Overview

PropertyValue
Node IDpostgres/query
Kindtransform
Modulepostgres-flowdsl
Repogo-module-postgres
Handlergithub.com/redelay/go-module-postgres/flowdsl.Query
Iconlucide:search
Color#3b82f6
Tagspostgres, read

Outputs

  • out — (no description)

Settings

PropertyTypeRequiredDefaultUI GroupDescription
outputKeystring—itemsOutput
paramsPathstring——Query
sqlstringyes—Query

Example

yaml
# Use this node in a flow:
nodes:
  - id: my_step
    name: My Step
    kind: transform
    action_ref: postgres/query
    config:
      outputKey: items
      paramsPath: some.packet.path
      sql: "value"

Postgres Exec

Run INSERT/UPDATE/DELETE. Emits affected count.

Postgres Transaction

Run multiple statements atomically (BEGIN/COMMIT/ROLLBACK).