/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 vote229 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
-1 vote175 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote286 views3 answers
Uninstall postgresql mac
SQL
0 vote184 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote211 views1 answer
Sqlite3 pragma foreign keys
SQL
3 votes319 views6 answers
Sql unique select
SQL
-1 vote181 views2 answers
Import data from excel to sql server automatically
SQL
0 vote237 views2 answers
Fanyi
SQL
0 vote186 views2 answers
Mysql calcular idade
SQL
16 votes161 views2 answers
Gremove folder from git
SQL