/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 votes193 views1 answer
SQL IF ELSE
SQL
0 vote177 views1 answer
Find all tables where column name exists oracle
SQL
0 vote187 views1 answer
Select even number id data from table
SQL
8 votes236 views3 answers
Postgres database sizes
SQL
0 vote212 views3 answers
Find below average salary in sql
SQL
10 votes129 views2 answers
Django mysql
SQL
0 vote179 views2 answers
Pl sql auto increment
SQL
0 vote217 views1 answer
Basic structure of sql expression having clause
SQL
2 votes234 views3 answers
How to replace null values in sql
SQL
2 votes175 views2 answers
Mysql user access to database
SQL