nodes/generated

Interface PostgresV2NodeParameters

Source
interface PostgresV2NodeParameters {
    columnToMatchOn?: string;
    combineConditions?: "AND" | "OR";
    dataMode?: "autoMapInputData" | "defineBelow";
    deleteCommand?: "delete" | "truncate" | "drop";
    limit?: number;
    operation?:
        | "update"
        | "upsert"
        | "executeQuery"
        | "insert"
        | "select"
        | "deleteTable";
    options?: {
        cascade?: boolean;
        connectionTimeout?: number;
        delayClosingIdleConnection?: number;
        largeNumbersOutput?: "text"
        | "numbers";
        outputColumns?: unknown[];
        queryBatching?:
            | "single"
            | "independently"
            | "transaction";
        queryReplacement?: string;
        replaceEmptyStrings?: boolean;
        skipOnConflict?: boolean;
        treatQueryParametersInSingleQuotesAsText?: boolean;
    };
    query?: string;
    restartSequences?: boolean;
    returnAll?: boolean;
    schema?: { mode: "list"
    | "name"; value: string };
    sort?: {
        values: {
            column?: string;
            direction?: "ASC" | "DESC";
        }[];
    };
    table?: { mode: "list"
    | "name"; value: string };
    valuesToSend?: {
        values: { column?: string; value?: string }[];
    };
    valueToMatchOn?: string;
    where?: {
        values: {
            column?: string;
            condition?: | "equal"
            | "!="
            | "<"
            | "<="
            | ">"
            | ">="
            | "IS NOT NULL"
            | "IS NULL"
            | "LIKE";
            value?: string;
        }[];
    };
}

Properties§

§readonly columnToMatchOn?: string

The column to compare when finding the rows to update. Choose from the list, or specify an ID using an expression. Type options: {"loadOptionsMethod":"getColumns","loadOptionsDependsOn":["schema.value","table.value"]}

§readonly combineConditions?: "AND" | "OR"

How to combine the conditions defined in "Select Rows": AND requires all conditions to be true, OR requires at least one condition to be true Default: "AND"

§readonly dataMode?: "autoMapInputData" | "defineBelow"

Whether to map node input properties and the table data automatically or manually Default: "autoMapInputData"

§readonly deleteCommand?: "delete" | "truncate" | "drop"

Default: "truncate"

§readonly limit?: number

Max number of results to return Default: 50 Type options: {"minValue":1}

§readonly operation?:
    | "update"
    | "upsert"
    | "executeQuery"
    | "insert"
    | "select"
    | "deleteTable"

Default: "insert"

§readonly options?: { ... }

Default: {}

§readonly query?: string

The SQL query to execute. You can use n8n expressions and $1, $2, $3, etc to refer to the 'Query Parameters' set in options below. Type options: {"editor":"sqlEditor","sqlDialect":"PostgreSQL"}

§readonly restartSequences?: boolean

Whether to reset identity (auto-increment) columns to their initial values

§readonly returnAll?: boolean

Whether to return all results or only up to a given limit

§readonly schema?: { ... }

The schema that contains the table you want to work on Default: {"mode":"list","value":"public"}

§readonly sort?: { ... }

Default: {} Type options: {"multipleValues":true}

§readonly table?: { ... }

The table you want to work on Default: {"mode":"list","value":""}

§readonly valuesToSend?: { ... }

Default: {} Type options: {"multipleValueButtonText":"Add Value","multipleValues":true}

§readonly valueToMatchOn?: string

Rows with a value in the specified "Column to Match On" that corresponds to the value in this field will be updated

§readonly where?: { ... }

If not set, all rows will be selected Default: {} Type options: {"multipleValues":true}