努力链接postgres数据库异步/等待承诺将结果发送到客户端(express)

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

// 创建PostgreSQL客户端
const client = new Client({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 'your_port',
});

// 连接到PostgreSQL数据库
client.connect();

// 定义路由处理程序
app.get('/', async (req, res) => {
  try {
    // 执行异步查询
    const result = await client.query('SELECT * FROM your_table');

    // 将结果发送到客户端
    res.json(result.rows);
  } catch (error) {
    console.error('Error executing query', error);
    res.status(500).json({ error: 'Internal server error' });
  }
});

// 启动Express服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});