/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

49 votes182 views6 answers
Get duplicate records in sql
SQL
1 vote109 views1 answer
Sql trigger before delete
SQL
0 vote106 views1 answer
Create table if not exist with exceptions
SQL
0 vote119 views1 answer
Mysql change timestamp on update
SQL
25 votes123 views5 answers
Uninstall mysql ubuntu
SQL
2 votes108 views1 answer
Sql missing records from another table
SQL
0 vote95 views1 answer
Sqlite to csv statement
SQL
0 vote114 views1 answer
What is mysql_pconnect
SQL
9 votes101 views2 answers
Cmd to rename a collumn name in sql
SQL
12 votes124 views6 answers
Change mysql root password
SQL