interface TimescaleDbNodeParameters {
additionalFields?: {
mode?: "independently" | "multiple" | "transaction";
queryParams?: string;
};
columns?: string;
operation?: "update"
| "executeQuery"
| "insert";
query?: string;
returnFields?: string;
schema?: string;
table?: string;
updateKey?: string;
}Properties§
Source§readonly additional
mode?: "independently" | "multiple" | "transaction";
queryParams?: string;
}
readonly additional
mode?: "independently" | "multiple" | "transaction";
queryParams?: string;
}
Source§readonly columns?: string
readonly columns?: string
Comma-separated list of the properties which should used as columns for the new rows
Source§readonly query?: string
readonly query?: string
The SQL query to execute. You can use n8n expressions or $1 and $2 in conjunction with query parameters. Type options: {"editor":"sqlEditor","sqlDialect":"PostgreSQL"}
Default: {}