# 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.