/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 vote109 views1 answer
Mysql copy table1 to table2
SQL
0 vote105 views1 answer
Mysql find db contarint
SQL
0 vote113 views1 answer
Hour and minute between two datatime sql
SQL
-2 votes127 views1 answer
Mysql not empty
SQL
0 vote100 views1 answer
Sql server manager close connection
SQL
4 votes113 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote95 views1 answer
Group by 15 minute interval sql server
SQL
0 vote58 views1 answer
Mysqli or pdo
SQL
0 vote113 views1 answer
Mysql cast null to string
SQL
0 vote105 views2 answers
How to create a table from another table in sql derby
SQL