/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

8 votes211 views3 answers
SQL column name
SQL
10 votes200 views4 answers
SELECT FROM WHERE
SQL
1 vote212 views1 answer
Sql current timestamp
SQL
0 vote191 views1 answer
Sql server 2012 create or alter procedure
SQL
8 votes199 views2 answers
Replace string value in sql
SQL
18 votes186 views3 answers
Mysql add column with default value
SQL
7 votes196 views3 answers
Sql update where id
SQL
1 vote204 views1 answer
Tsql find foreign key references
SQL
0 vote196 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
22 votes331 views4 answers
Mysql date format
SQL