/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 vote144 views1 answer
Sql delete where x or y or z
SQL
14 votes157 views4 answers
Import database through command line
SQL
0 vote283 views1 answer
Generate a random otp in sql server
SQL
3 votes190 views2 answers
How to list columns for particular tables in postgresql
SQL
4 votes157 views1 answer
Mysql set max connections
SQL
8 votes155 views2 answers
Safe update mode in mysql
SQL
6 votes139 views1 answer
Phpmyadmin reset root password
SQL
25 votes167 views4 answers
Metadata
SQL
0 vote160 views1 answer
Mysql average from two table
SQL
2 votes162 views1 answer
Drop all foreign key constraints mysql
SQL