Using pgp.helpers.insert with RETURNING in statement

Question

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?

See `Extras` section in the answer here: http://stackoverflow.com/questions/37300997/multi-row-insert-with-pg-promise — vitaly-t, Apr 21 '17 at 11:39
That was easy :) Thank you. Please make an answer, so I can credit you. — Michael Nielsen, Apr 21 '17 at 11:42

score 3 · Accepted Answer · edited May 23 '17 at 12:17

3

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.

edited May 23 '17 at 12:17

Community

answered Apr 21 '17 at 11:45

vitaly-t

1 Answers1