使用带有数组映射的Async/Await将数据插入postgres表

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

// 创建数据库连接池
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 'your_port',
});

async function insertData() {
  try {
    // 获取数据库连接
    const client = await pool.connect();

    // 要插入的数据
    const data = {
      name: 'John Doe',
      age: 30,
      hobbies: ['reading', 'gaming', 'coding'],
    };

    // 使用数组映射将数据插入表
    const query = 'INSERT INTO your_table (name, age, hobbies) VALUES ($1, $2, $3)';
    const values = [data.name, data.age, data.hobbies];
    await client.query(query, values);

    // 释放数据库连接
    client.release();

    console.log('数据插入成功！');
  } catch (error) {
    console.error('数据插入失败：', error);
  }
}

insertData();