/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

0 vote128 views1 answer
Sql server whoami
SQL
3 votes130 views1 answer
Mysql insert on dupèlicate
SQL
0 vote144 views1 answer
Create dump file mysql workbench
SQL
2 votes131 views1 answer
Sql as
SQL
0 vote136 views1 answer
Oracle NLS_CHARACTERSET
SQL
2 votes204 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote134 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote195 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote164 views1 answer
Postgresql if 0 then 1
SQL
-1 vote142 views1 answer
Mysql select count if contains
SQL