使用pg-promise格式化JSON输出，将外键封装为对象

npm install pg-promise

const pgp = require('pg-promise')();

const db = pgp('postgres://username:password@host:port/database');

db.any('SELECT * FROM table')
  .then(data => {
    const jsonOutput = JSON.stringify(data);
    console.log(jsonOutput);
  })
  .catch(error => {
    console.error(error);
  });

db.any('SELECT t1.*, t2.name AS foreign_key_name FROM table1 t1 JOIN table2 t2 ON t1.foreign_key = t2.id')
  .then(data => {
    const jsonOutput = JSON.stringify(data);
    console.log(jsonOutput);
  })
  .catch(error => {
    console.error(error);
  });