Last Updated: 3/9/2026

Multiple rows

On dialects that support it (for example PostgreSQL) you can insert multiple rows by providing an array. Note that the return value is once again very dialect-specific. Some databases may only return the id of the last inserted row and some return nothing at all unless you call returning.

import { multipleRows } from ’./0020-multiple-rows’

:::info[More examples] The API documentation is packed with examples. The API docs are hosted here , but you can access the same documentation by hovering over functions/methods/classes in your IDE. The examples are always just one hover away!

For example, check out these sections:

• values method 
• onConflict method 
• returning method 
• insertInto method  :::