/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

1 vote374 views1 answer
Quit mysql
SQL
0 vote366 views1 answer
Creation d'un trigger sql
SQL
0 vote343 views1 answer
Implicit inner join table alias with id values
SQL
0 vote340 views1 answer
Lister les index d'une table oracle
SQL
0 vote405 views1 answer
"Hello User Name"
SQL
0 vote365 views1 answer
Merge clause with inner join
SQL
0 vote359 views1 answer
Mysql count number of occurrences in a column
SQL
8 votes377 views1 answer
How to check mysql version in xampp
SQL
7 votes394 views1 answer
Mysql remote connection command line
SQL
0 vote357 views1 answer
How to find username and password in oracle 18c
SQL