nodes/generated

Interface PostgresV1NodeParameters

Source
interface PostgresV1NodeParameters {
    additionalFields?: {
        largeNumbersOutput?: "text" | "numbers";
        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 additionalFields?: {
    largeNumbersOutput?: "text" | "numbers";
    mode?: "independently" | "multiple" | "transaction";
    queryParams?: string;
}

Default: {}

Source§

readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows. You can use type casting with colons (:) like id:int.

Source§

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

Default: "insert"

Source§

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

Source§

readonly returnFields?: string

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

Source§

readonly schema?: string

Name of the schema the table belongs to Default: "public"

Source§

readonly table?: string

Name of the table in which to insert data to

Source§

readonly updateKey?: string

Comma-separated list of the properties which decides which rows in the database should be updated. Normally that would be "id". Default: "id"