Postgres Trigger

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

Credentials

postgres (alias: @postgres)

CREDENTIAL @postgres = postgres "My Postgres Trigger"

Parameters

Parameter	Type	Default	Details
triggerMode	options	"createTrigger"	createTrigger, listenTrigger
schema	resourceLocator	{...}	required; modes: list, name
tableName	resourceLocator	{...}	required; modes: list, name
channelName	string	""	required
firesOn	options	"INSERT"	INSERT, UPDATE, DELETE
additionalFields	collection	{}	keys: channelName, functionName, replaceIfExists, triggerName
options	collection	{}	keys: connectionTimeout, delayClosingIdleConnection

additionalFields children:

Parameter	Type	Default	Details
channelName	string	""
functionName	string	""
replaceIfExists	boolean	false
triggerName	string	""

options children:

Parameter	Type	Default	Details
connectionTimeout	number	30
delayClosingIdleConnection	number	0

Example

NODE "postgresTrigger" @postgres AS "Postgres Trigger" {
  channelName: {{ $json.channelName }}
}