CODEWITHSUNDEEP
sqlnode.jspostgresqlpg-promise
Michael Nielsen
Michael Nielsen

Reputation: 1242

Using pgp.helpers.insert with RETURNING in statement

I've got really good help with creating INSERT statements dynamically in a previous question: NodeJS and pg-promise, insert dynamically from JSON-object

I've tried to look at the docs, and would like to include RETURNING in the INSERT statement, so I get the inserted record as output with pg-promise.

I'm using NodeJS with pg-promise.

Is it possible to return the inserted record with all columns?

Upvotes: 2

Views: 2114

Answers (1)

vitaly-t
vitaly-t

Reputation: 25840

You do so simply by appending the RETURNING clause to your query, and then executing it with a method according to the expected result.

For a complete example see the Extras section in Multi-row insert with pg-promise.

Upvotes: 3

Related Questions