/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 vote302 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote290 views1 answer
Postgresql delete cascade
SQL
20 votes291 views3 answers
SQL query rename table
SQL
0 vote299 views1 answer
Postgresql show owner of database
SQL
0 vote285 views1 answer
Sql select merge multiple values
SQL
0 vote274 views2 answers
Select limit ms sql
SQL
0 vote275 views1 answer
MySql get primary keys of table
SQL
0 vote285 views1 answer
Postgres enumerated type
SQL
5 votes286 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote309 views1 answer
Sql missing values
SQL