SQL · Writing data

insert returning

Returns generated values such as ids from the inserted rows. PostgreSQL and SQLite support it.

sqlRunnable example sql course

Syntax

insert … returning id

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER PRIMARY KEY, body TEXT);
INSERT INTO notes (body) VALUES ('hello') RETURNING id, body;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.