postreqsql:插入到2个由外键链接的表中，以便共享序列id

const { Pool } = require('pg');
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432,
});

async function insertData() {
  const client = await pool.connect();

  try {
    await client.query('BEGIN');

    // 插入数据到第一个表
    const insertQuery1 = 'INSERT INTO table1 (id, column1) VALUES (DEFAULT, $1) RETURNING id';
    const values1 = ['value1'];
    const result1 = await client.query(insertQuery1, values1);
    const generatedId = result1.rows[0].id;

    // 插入数据到第二个表
    const insertQuery2 = 'INSERT INTO table2 (id, column2, table1_id) VALUES (DEFAULT, $1, $2)';
    const values2 = ['value2', generatedId];
    await client.query(insertQuery2, values2);

    await client.query('COMMIT');
    console.log('数据插入成功！');
  } catch (error) {
    await client.query('ROLLBACK');
    console.error('数据插入失败：', error);
  } finally {
    client.release();
  }
}

insertData();