/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 vote28 views5 answers
Sql table intermédiaire
SQL
0 vote28 views1 answer
Sql view index
SQL
0 vote29 views1 answer
How to increase the width of the screen in oracle
SQL
3 votes33 views1 answer
Mysql load sql from file
SQL
0 vote37 views1 answer
How to map sql column to custom names
SQL
-1 vote27 views3 answers
Update mongodb version ubuntu
SQL
1 vote28 views1 answer
Where date = max(date) in sql
SQL
0 vote28 views1 answer
Safe mysql
SQL
0 vote32 views1 answer
Table or view does not exist
SQL
1 vote31 views2 answers
Mssql show database size
SQL