/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

3 votes332 views1 answer
How to get yesterday date in sql
SQL
19 votes249 views6 answers
Sql drop table if exists
SQL
1 vote258 views1 answer
Postgresql if 0 then 1
SQL
0 vote250 views1 answer
Selecting all columns from table sql database
SQL
0 vote261 views2 answers
Disallowed function mysql to_date()
SQL
4 votes229 views4 answers
Update select mysql
SQL
0 vote242 views2 answers
Search stored procedures
SQL
0 vote248 views1 answer
Select nth row in mysql
SQL
0 vote235 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
-1 vote224 views2 answers
How to display top 50 rows?
SQL