/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 vote331 views1 answer
Automate mysql cli query
SQL
0 vote351 views1 answer
Restore backupfile discourse
SQL
7 votes340 views1 answer
Sql management studio display line numbers
SQL
2 votes414 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
16 votes341 views3 answers
Order by sql query
SQL
0 vote339 views1 answer
IIF
SQL
0 vote392 views1 answer
Sqlalchemy _in array sqlite
SQL
2 votes385 views3 answers
How to check current user in mySQL
SQL
0 vote353 views1 answer
Mysql set column equal to another automatic
SQL
0 vote339 views1 answer
Opensuse start MySQL
SQL