将node.js 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',
});

client.connect();

const query = 'SELECT * FROM your_table';
const result = await client.query(query);
const data = result.rows;

client.end();

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

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

async function getDataFromDatabase() {
  try {
    await client.connect();

    const query = 'SELECT * FROM your_table';
    const result = await client.query(query);
    const data = result.rows;

    console.log(data);
  } catch (error) {
    console.error('Error:', error);
  } finally {
    await client.end();
  }
}

getDataFromDatabase();