whenNotMatchedInsert

fun whenNotMatchedInsert(and: Op<Boolean>? = null, overridingUserValue: Boolean = false, overridingSystemValue: Boolean = false, body: (InsertStatement<Int>) -> Unit)

Defines an insert operation to be performed when there is no matching record in the destination table.

Parameters

overridingUserValue

Postgres only. Indicates whether to use the OVERRIDING USER VALUE clause for the insert.

overridingSystemValue

Postgres only. Indicates whether to use the OVERRIDING SYSTEM VALUE clause for the insert.

and

An additional optional condition Op to refine when the insert should take place.

body

A lambda to configure the InsertStatement in which the required columns and corresponding values are specified for the insert operation.