nodes/generated

Interface QuestDbNodeParameters

Source
interface QuestDbNodeParameters {
    additionalFields?: {
        mode?: "independently" | "transaction";
        queryParams?: string;
    };
    columns?: string;
    operation?: "executeQuery"
    | "insert";
    query?: string;
    returnFields?: string;
    table?: string;
}

Properties§

§readonly additionalFields?: { ... }

Default: {}

§readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows

§readonly operation?: "executeQuery" | "insert"

Default: "insert"

§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"}

§readonly returnFields?: string

Comma-separated list of the fields that the operation will return Default: "*"

§readonly table?: string

Name of the table in which to insert data to