/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 vote345 views1 answer
Sql server select record with max id
SQL
0 vote327 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
11 votes329 views4 answers
Round in sql
SQL
0 vote328 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote332 views1 answer
Oracle add proxy
SQL
0 vote317 views1 answer
Soql more than today
SQL
20 votes344 views5 answers
Sql show tables
SQL
8 votes322 views1 answer
Insert a select statement into a table
SQL
0 vote329 views1 answer
Get cpu details sql
SQL
9 votes343 views4 answers
SQL Date Format
SQL