/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 vote198 views1 answer
Ubuntu access database from terminal
SQL
0 vote189 views1 answer
View to table sql
SQL
0 vote248 views1 answer
Mysql get longest string in column
SQL
2 votes182 views1 answer
No data found oracle
SQL
0 vote179 views2 answers
MySQL top percent
SQL
1 vote182 views1 answer
Count mysql server db tables
SQL
4 votes167 views2 answers
Oracle set date format
SQL
0 vote186 views1 answer
Oracle search in date columns
SQL
24 votes198 views4 answers
Mysql datetime
SQL
0 vote178 views1 answer
How to install Firebird
SQL