/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 vote156 views1 answer
Selects all the columns from the sailors table
SQL
1 vote144 views1 answer
Sql server reseed single table
SQL
1 vote165 views1 answer
How to use db.execute
SQL
5 votes164 views3 answers
Mysql update field from one table to another
SQL
1 vote171 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote187 views1 answer
Show per page table in xampp
SQL
0 vote424 views1 answer
Create pl/sql stored procedure
SQL
65 votes455 views6 answers
Sql add column to table
SQL
2 votes192 views6 answers
In operator in sql
SQL
2 votes150 views1 answer
Postgresql change value in column
SQL