/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 vote156 views1 answer
Sql create and grant user access to database
SQL
3 votes130 views2 answers
Sql random integer
SQL
0 vote166 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote115 views2 answers
Mysql trim whitespace
SQL
1 vote128 views1 answer
STOP message of how many rows affected sql
SQL
0 vote185 views1 answer
How to rename a database in tsql
SQL
5 votes130 views3 answers
MySql get fields of table
SQL
0 vote124 views1 answer
Sql string contains case sensitive
SQL
3 votes123 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote116 views1 answer
Incorrect datetime value sql table error 1292
SQL