json - Nodejs如何将postgresql查询结果的行转换为json数组？

Question

我从 postgreSQL 数据库得到以下查询结果，然后我想发送应该只有部分的响应：行到客户端。我需要响应是 json 格式，所以你能告诉我如何将查询结果：行转换为 json 数组吗？

Result {
      command: 'SELECT',
      rowCount: 1,
      oid: NaN,
      rows:
       [ anonymous {
           uid: 23,
           name: 'Test Human',
           email: '[e-mail]',
           password: 'test',
           created: 2018-08-24T09:44:19.659Z,
           terminited: null } 
         anonymous {
           uid: 12,
           name: 'Test Animal',
           email: '[e-mail]',
           password: 'hello',
           created: 2018-08-24T09:44:19.659Z,
           terminited: null }
      ],
      fields:
       ...
       _parsers:
       [ [Function: parseInteger],
         [Function: noParse],
         [Function: noParse],
         [Function: noParse],
         [Function: parseDate],
         [Function: parseDate] ],
      RowCtor: [Function: anonymous],
      rowAsArray: false,
      _getTypeParser: [Function: bound ] }

Node.js 代码：

// router for get friends  information
router.get("/getfriends", (req, res) => {

   const uid = req.query.uid;
   pool.connect((err, client, done) => {
    if (err) throw err;
    const fetchRow = async() =>{
       await client.query('SELECT * FROM friends where follower = $1 ORDER by id ASC', [uid], (err, result) => {
         done()
         if(err){
           console.log(err.stack)
           res.status(400).json(err)
         } else {
           /*here I want to response rows only with JSON format, but result.rows doesn't realise that...*/
           console.log(result.rows)
           res.status(200).json(result.rows)
        }
      })
    }
    fetchRow()
   })
})

标签： jsonnode.jspostgresql