Timescale Db

Node: timescaleDb · Full type: n8n-nodes-base.timescaleDb · Version: 1

Credentials

timescaleDb (alias: @timescale)

CREDENTIAL @timescale = timescaleDb "My Timescale Db"

Operations

executeQuery

Parameter	Type	Default	Details
query	string	""	required

insert

Parameter	Type	Default	Details
schema	string	"public"	required
table	string	""	required
columns	string	""
returnFields	string	"*"

update

Parameter	Type	Default	Details
schema	string	"public"	required
table	string	""	required
updateKey	string	"id"	required
columns	string	""
returnFields	string	"*"

Common Parameters

Parameter	Type	Default	Details
additionalFields	collection	{}	keys: mode, queryParams

Parameter Details

additionalFields children:

Parameter	Type	Default	Details
mode	options	"multiple"	independently, multiple, transaction
queryParams	string	""

Example

NODE "timescaleDb" @timescale AS "Timescale Db" {
  operation: "executeQuery",
  query: {{ $json.query }},
  schema: {{ $json.schema }},
  table: {{ $json.table }},
  updateKey: {{ $json.updateKey }}
}