/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 vote204 views1 answer
Psql connections
SQL
6 votes235 views6 answers
Rename column postgres
SQL
0 vote209 views1 answer
How to to get time in sql
SQL
1 vote186 views1 answer
Oracle sql listagg
SQL
1 vote192 views2 answers
Mysql: command not found
SQL
0 vote226 views1 answer
Sql multiple into
SQL
2 votes293 views1 answer
Oracle list grants on package
SQL
0 vote189 views1 answer
Sql tabelle erstellen
SQL
1 vote214 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote212 views1 answer
How to access to mysql without root
SQL