How to insert array of values in postgresql using nodejs

Question

for(i in req.body.category_id){
db.query('INSERT INTO guide_categories(category_id) values($1)', [req.body.category_id[i]],function(err,category) {
  if(err) return next(err);                         
  return console.log("success");           
  });                             
}

Here I am passing the array of values from postman as category_id:["3","1"], and only the last value of the array is being inserted and the rest are not. How do I solve this?

Multiple inserts should be done via a single, multi-insert query. Example: [Multi-row insert](https://stackoverflow.com/questions/37300997/multi-row-insert-with-pg-promise). — vitaly-t, Dec 29 '17 at 12:27

score 1 · Accepted Answer · answered Dec 29 '17 at 06:15

1

change to

for(i in req.body.category_id){
db.query('INSERT INTO guide_categories(category_id) values($1) returning *', [req.body.category_id[i]], (err,category) => {
  if(err) {
    console.log(err);     
    } else {                    
    console.log(category);   
  }        
  };                             
}

and populate the output of console.log

answered Dec 29 '17 at 06:15

Vao Tsun

47,234
13
100
132

I assume you return after first iteration?.. not going for next results – Vao Tsun Dec 29 '17 at 06:28

How to insert array of values in postgresql using nodejs

1 Answers1