Node Postgres根据数组和静态变量插入多行

npm install pg

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

const client = new Client({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 'your_port',
});

await client.connect();

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

const staticVariable = 'example';

const query = {
  text: 'INSERT INTO your_table (name, age, static_variable) VALUES ($1, $2, $3)',
  values: dataArray.map(data => [data.name, data.age, staticVariable]),
};

await client.query(query);

await client.end();