What is the purpose of `RETURNING` clause in PostgreSQL DML statements?

Question

Advanced SQL Developer — Medium

What is the purpose of `RETURNING` clause in PostgreSQL DML statements?

Accepted Answer

The `RETURNING` clause in PostgreSQL DML statements allows you to retrieve specified column values from rows affected by INSERT, UPDATE, or DELETE operations. This eliminates the need for an additional SELECT query to fetch auto-generated IDs or modified values.