---
title: 'Returning data'
---

# Returning data

On supported dialects like PostgreSQL you need to chain `returning` to the query to get
the inserted row's columns (or any other expression) as the return value. `returning`
works just like `select`. Refer to `select` method's examples and documentation for
more info.

import {
  Playground,
  exampleSetup,
} from '../../../src/components/Playground'

import {
  returningData
} from './0030-returning-data'

<div style={{ marginBottom: '1em' }}>
  <Playground code={returningData} setupCode={exampleSetup} />
</div>

:::info[More examples]
The API documentation is packed with examples. The API docs are hosted [here](https://kysely-org.github.io/kysely-apidoc/),
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](https://kysely-org.github.io/kysely-apidoc/classes/InsertQueryBuilder.html#values)
 - [onConflict method](https://kysely-org.github.io/kysely-apidoc/classes/InsertQueryBuilder.html#onConflict)
 - [returning method](https://kysely-org.github.io/kysely-apidoc/classes/InsertQueryBuilder.html#returning)
 - [insertInto method](https://kysely-org.github.io/kysely-apidoc/classes/Kysely.html#insertInto)
:::
