Performs the insert (...) values action.
This method is similar to values, so see the documentation for that method for more examples.
To perform the do nothing action, see thenDoNothing.
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenNotMatched()
.thenInsertValues({
first_name: 'John',
last_name: 'Doe',
})
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
insert ("first_name", "last_name") values ($1, $2)
Generated using TypeDoc
Performs the
do nothingaction.This is supported in PostgreSQL.
To perform the
insertaction, see thenInsertValues.Examples
The generated SQL (PostgreSQL):