/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

23 votes205 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote203 views1 answer
Renommer base sql
SQL
0 vote197 views1 answer
Sql server alter table add column tinyint
SQL
0 vote291 views1 answer
Add user mysql wordpress
SQL
4 votes185 views1 answer
Oracle delete last row
SQL
0 vote191 views1 answer
Oracle simple quote
SQL
7 votes179 views3 answers
Sql get last inserted row
SQL
0 vote184 views1 answer
Ignore case in string sql
SQL
0 vote181 views1 answer
C# mysql data reader from two tables
SQL
0 vote189 views1 answer
Linebreak sql
SQL