RETURNING

A clause on INSERT, UPDATE or DELETE that returns the rows it wrote, such as the id of a new row.

In more detail

PostgreSQL has long supported it and SQLite since version 3.35. A follow-up SELECT does the same job portably.

Related terms

Taught in

References