Postgres

Node: postgres · Full type: n8n-nodes-base.postgres · Version: 2.6

Credentials

postgres (alias: @postgres)

CREDENTIAL @postgres = postgres "My Postgres"

Operations

deleteTable

No additional parameters.

executeQuery

No additional parameters.

insert

No additional parameters.

upsert

No additional parameters.

select

No additional parameters.

update

No additional parameters.

Common Parameters

Parameter	Type	Default	Details
schema	resourceLocator	{...}	required; modes: list, name
table	resourceLocator	{...}	required; modes: list, name

Parameter Details

where children:

values group:

Parameter	Type	Default	Details
column	options	""
condition	options	"equal"	equal, !=, LIKE, >, <, >=, <=, IS NULL, ... (9 total)
value	string	""

options children:

Parameter	Type	Default	Details
cascade	boolean	false
connectionTimeout	number	30
delayClosingIdleConnection	number	0
queryBatching	options	"single"	single, independently, transaction
queryReplacement	string	""
treatQueryParametersInSingleQuotesAsText	boolean	false
outputColumns	multiOptions	[]
largeNumbersOutput	options	"text"	numbers, text
skipOnConflict	boolean	false
replaceEmptyStrings	boolean	false

valuesToSend children:

values group:

Parameter	Type	Default	Details
column	options	[]
value	string	""

sort children:

values group:

Parameter	Type	Default	Details
column	options	""
direction	options	"ASC"	ASC, DESC

Example

NODE "postgres" @postgres AS "Postgres" {
  operation: "executeQuery",
  query: {{ $json.query }}
}