/SQL/Return insert results in POSTGRESQL

Return insert results in POSTGRESQL

# to select specific columns
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING id, firstname;
# to return every column
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING *;

Similar codes

-1 vote274 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
8 votes271 views1 answer
Sql limit results returned
SQL
4 votes268 views1 answer
Mysql ip address data type
SQL
0 vote250 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote260 views1 answer
Datetime postgres typeorm
SQL
5 votes226 views1 answer
Postgres upsert
SQL
1 vote254 views1 answer
Mysql get latest duplicate rows
SQL
1 vote260 views1 answer
Mysql month name extract
SQL
1 vote237 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote270 views1 answer
Oracle enable job
SQL