Postgres & Javascript -如何格式化Nodejs中的对象数组以插入Postgres JSON列？

npm install pg

const { Pool } = require('pg');

const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432, // 默认PostgreSQL端口号
});

async function insertData(data) {
  try {
    const client = await pool.connect();
    const formattedData = JSON.stringify(data); // 将对象数组转换为JSON字符串
    const query = 'INSERT INTO your_table (json_column) VALUES ($1)';
    const values = [formattedData];
    await client.query(query, values);
    client.release();
    console.log('数据插入成功！');
  } catch (error) {
    console.error('数据插入失败：', error);
  }
}

const data = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Bob', age: 35 },
];

insertData(data);