How to get the inserted row?

[busslina]

Is there a way to get the inserted row data on an INSERT query without executing an extra SELECT query?

[busslina]

SOLVED:

INSERT INTO employees (name, age)
VALUES ('John Doe', 30)
RETURNING id;

INSERT INTO your_table_name (column1, column2, ...)
VALUES (value1, value2, ...)
RETURNING *;