/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

2 votes338 views5 answers
Install postgresql 10 centos 7
SQL
0 vote284 views1 answer
SQL server select to get sum of hours
SQL
5 votes364 views2 answers
How to ascending order in sql
SQL
0 vote318 views1 answer
Less than and between in sql query
SQL
1 vote324 views1 answer
Oracle select first result
SQL
0 vote320 views1 answer
How to access to mysql without root
SQL
0 vote512 views1 answer
Dublicate row sql
SQL
0 vote327 views1 answer
Resullt all update knex mysql
SQL
0 vote319 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote326 views1 answer
How to add timestamp column in mysql
SQL