English | 简体中文

api-docs / org.ktorm.support.postgresql / BulkInsertExpression / <init>

<init>

BulkInsertExpression(
    table: TableExpression,
    assignments: List<List<ColumnAssignmentExpression<*>>>,
    conflictColumns: List<ColumnExpression<*>> = emptyList(),
    updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(),
    returningColumns: List<ColumnExpression<*>> = emptyList(),
    isLeafNode: Boolean = false,
    extraProperties: Map<String, Any> = emptyMap())

Bulk insert expression, represents a bulk insert statement in PostgreSQL.

For example:

insert into table (column1, column2)
values (?, ?), (?, ?), (?, ?)...
on conflict (...) do update set ...`