/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 vote206 views1 answer
Oracle activate job
SQL
10 votes200 views1 answer
Oracle dependencies table
SQL
0 vote193 views1 answer
Sqlite version check
SQL
4 votes196 views2 answers
Postgresql reset sequence
SQL
0 vote193 views1 answer
Delete * from where id = 1;
SQL
1 vote194 views1 answer
Sql server find tables referenced foreign key
SQL
150 votes339 views10 answers
Grepper
SQL
0 vote207 views2 answers
How to delete the rows with null values in mysql
SQL
44 votes253 views4 answers
Mysql alter table add column first
SQL
2 votes202 views1 answer
Mysql create user with remote access
SQL