/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

1 vote333 views1 answer
Delete dublicate rows sql
SQL
4 votes306 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote304 views1 answer
Get current date in pyspark sql
SQL
0 vote242 views1 answer
Sql truncate table referencing itself
SQL
0 vote349 views1 answer
Drop table BigQuery table columns
SQL
0 vote281 views1 answer
Pgsql is not permitted to log in
SQL
0 vote287 views1 answer
Group by two columns postgres
SQL
0 vote282 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote292 views1 answer
Sql server Cost Fifo query
SQL
0 vote276 views2 answers
Mysql create table if not exists
SQL