/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 vote152 views1 answer
Mysql timeout 30 seconds
SQL
27 votes203 views6 answers
Set password mysql
SQL
0 vote188 views1 answer
Sql find all different values in column
SQL
0 vote194 views1 answer
Sql find record cannot cast date
SQL
3 votes192 views1 answer
Oracle undo tablespace list by user
SQL
6 votes325 views1 answer
Sql insert values into table
SQL
2 votes202 views1 answer
Oracle apex who is connected
SQL
1 vote210 views1 answer
How not to sort by average rating
SQL
20 votes184 views3 answers
SQL query rename table
SQL
1 vote172 views1 answer
Using SQL in rails migration
SQL