# Select Array from MSSQL and insert into postgresql

**URL:** <https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820>\
**Category:** General\
**Created:** [5 December 2019 10:01 UTC](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820 "2019-12-05T10:01:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nameegal](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@nameegal](https://discourse.nodered.org/u/nameegal)\
**Post date:** [5 December 2019 10:01 UTC](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820/1 "2019-12-05T10:01:24Z")

</div>

Hi. I try to read an array from MSSQL database and insert the Array data into a postgresql database. From the postgres node I get the "Error: msg.payload must be an array of queries".  
The Output from mssql is an Array

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/5/5afd5dbb1bc712b74b799196e91bea33ce632c97.png)  
the function node has follow Content:

```auto
var newMsg = { payload: msg.payload.length };
return newMsg;
var i;
var sql="";
var outputs=[];
var TagNumber;
var KeeperID;

for (i = 0; i< msg.payload.length; i++) {
    TagNumber=msg.payload.Rows[i].TagNumber;
    KeeperID=msg.payload.Rows[i].KeeperID;
    sql="INSERT INTO test_garment"+
    "VALUES (\""+TagNumber+"\",\""+KeeperID+"\");";
 outputs.push({topic:sql});
}  

```

I dint see whats wrong ...