Is there a way to do bulk insert in Postgresql from node.js?

Question

I'm using pg module (and the promise version pg-promise-strict).

When I need to insert 1k records I must send to the server one by one.

I can't build a 1k record INSERT because my organization policies: the data MUST be sended separately (as seen in https://github.com/brianc/node-postgres/wiki/Client#method-query-parameterized)

I try to write a plsql function that does the bulk insert and send all the data in an array (or in a string, I try boths):

client.query("select bulk_insert", [allTheData], cb);

And I obtain the following message:

index row requires 38656 bytes, maximum size is 8191

Notes

How can I do the bulk insert sending the data separately?

icuken · Accepted Answer · 2016-09-26 09:28:51Z

1

I think you should take a look to a plugin from the same author, as you database client library: https://github.com/brianc/node-pg-copy-streams which exactly made for COPY command.

answered Sep 26, 2016 at 9:28

icuken

1,36610 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

from json object rather than file !