/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 vote333 views2 answers
Pad zero sql server
SQL
8 votes354 views2 answers
How to fetch data from database without last column
SQL
1 vote360 views1 answer
How to see logical reads in sql server
SQL
6 votes364 views2 answers
Foreign key sqlite3 python
SQL
2 votes299 views1 answer
Mysql auto increment jumping
SQL
0 vote313 views1 answer
Xampp mysql version
SQL
2 votes308 views1 answer
Get first 3 letters name in sql
SQL
0 vote654 views1 answer
Create pl/sql stored procedure
SQL
1 vote336 views1 answer
Influxdb export to csv
SQL
0 vote345 views1 answer
Oracle swap partition
SQL