/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 votes145 views2 answers
Mysql get time from datetime
SQL
1 vote135 views1 answer
Scaffold mysql database
SQL
0 vote137 views1 answer
Console output pl sql
SQL
1 vote135 views1 answer
Sql delete row with auto increment
SQL
0 vote148 views1 answer
Postgres sql alter table delete row
SQL
0 vote145 views1 answer
Mysql replication change database name
SQL
0 vote145 views1 answer
Pl sql search saurce code
SQL
0 vote158 views1 answer
Excel vba import data to sql server
SQL
0 vote141 views1 answer
Oracle archivelog usage
SQL
0 vote145 views1 answer
Oracle NLS_CHARACTERSET
SQL