/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

9 votes179 views2 answers
Nosql databases
SQL
0 vote175 views1 answer
How to check xampp mysql password
SQL
0 vote132 views1 answer
Sql count how many times a value appears
SQL
2 votes192 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote177 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
2 votes209 views3 answers
Xampp mysql database not starting
SQL
0 vote150 views1 answer
Mql5 list all available symbols
SQL
0 vote165 views1 answer
Sql server select top 2 of each group
SQL
0 vote566 views2 answers
Zsh: command not found: mysq
SQL
0 vote174 views1 answer
How to combine rows in sql server procedure
SQL