如何在TypeScript中输入node-postgres异步查询函数？

npm install pg

import { Pool, Client } from 'pg';

// 创建连接池
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: your_port,
});

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

// 使用连接池执行异步查询
const executeQueryWithPool = async () => {
  const client = await pool.connect();
  try {
    const res = await client.query('SELECT * FROM your_table');
    console.log(res.rows);
  } finally {
    client.release();
  }
};

// 使用客户端对象执行异步查询
const executeQueryWithClient = async () => {
  await client.connect();
  try {
    const res = await client.query('SELECT * FROM your_table');
    console.log(res.rows);
  } finally {
    client.end();
  }
};

// 调用上述函数执行查询
executeQueryWithPool();
executeQueryWithClient();