/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 vote107 views1 answer
How to count with except in psql
SQL
0 vote133 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
6 votes122 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote122 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote115 views2 answers
How to get json data mysql
SQL
0 vote135 views1 answer
Traccar mysql
SQL
2 votes132 views1 answer
Oracle convert run_duration to number
SQL
1 vote121 views1 answer
Postgresql transaction discard all
SQL
0 vote114 views1 answer
Select last N rows mysql
SQL
0 vote124 views1 answer
How to list function in psql
SQL