/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

21 votes213 views6 answers
Change column in mysql
SQL
2 votes202 views1 answer
Oracle sql day of month from date
SQL
0 vote198 views1 answer
Can we rollback deleted data in sql
SQL
0 vote200 views1 answer
Get all employees if name ends with in sql
SQL
33 votes208 views6 answers
Change column name in mysql
SQL
0 vote263 views1 answer
Select count concat string sql server
SQL
7 votes185 views1 answer
Safe mode mysql
SQL
0 vote205 views1 answer
Mysql sql.gz
SQL
24 votes215 views4 answers
Postgres delete database
SQL
2 votes208 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL