如果从嵌套函数调用，则无法从nodejs中的postgres获取结果

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

async function getDataFromPostgres() {
  const pool = new Pool({
    user: 'your_username',
    host: 'your_host',
    database: 'your_database',
    password: 'your_password',
    port: 'your_port',
  });

  try {
    const client = await pool.connect();
    const result = await client.query('SELECT * FROM your_table');
    client.release();
    return result.rows;
  } catch (error) {
    throw new Error(`Failed to get data from PostgreSQL: ${error}`);
  } finally {
    pool.end();
  }
}

async function main() {
  try {
    const data = await getDataFromPostgres();
    console.log(data);
    // 在这里处理获取到的PostgreSQL查询结果
  } catch (error) {
    console.error(error);
  }
}

main();