tags |
---|
database, potsgresql, sql, english |
You can return any information about any inserted element in the INSERT
statement by using the RETURNING ...
clause
INSERT INTO roles (name)
VALUES ('master')
RETURNING role_id
So after RETURNING
you choose all the columns you want to get
Very useful along [[The WITH statement]] to chain a bunch of insertions atomically without using transactions
- Started using the SQL language in PostgreSQL. Working on a tiny family project