/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 votes228 views1 answer
Datetrunc
SQL
0 vote219 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
4 votes230 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote234 views1 answer
Create bdd mysql
SQL
0 vote219 views1 answer
How to output a different column name in mysql
SQL
0 vote265 views3 answers
Postgres trim string
SQL
0 vote233 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote218 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote241 views1 answer
Where date = max(date) in sql
SQL
1 vote228 views1 answer
Oracle sql listagg
SQL