/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 vote143 views1 answer
Mysql where don't have string
SQL
0 vote150 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
6 votes140 views4 answers
Sqlite drop table
SQL
0 vote165 views1 answer
Create query in where clasue
SQL
0 vote169 views1 answer
Mysql multiple group by
SQL
0 vote157 views1 answer
Sort by last two number sql
SQL
0 vote154 views1 answer
Distance calculator from lat long sql query
SQL
3 votes157 views2 answers
See mysql users ubuntu
SQL
0 vote144 views1 answer
Can we rollback in sql
SQL
0 vote167 views1 answer
Python sqlalchemy connection show server
SQL