/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 vote349 views1 answer
Sql date between one week
SQL
0 vote323 views1 answer
Insert array into mysql column
SQL
0 vote353 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote341 views2 answers
How to combine 2 tables in MySQL
SQL
15 votes352 views6 answers
Laravel db transaction
SQL
1 vote326 views3 answers
How to truncate foreign key constraint table
SQL
4 votes330 views3 answers
Copy table postgres
SQL
3 votes368 views2 answers
How to delete git repo locally
SQL
1 vote375 views2 answers
Install sql server management studio ubuntu
SQL
1 vote361 views1 answer
Sql view where tables have same column name combine results
SQL