如何为Postgres池创建module.exports

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

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

const getUsers = async () => {
  const client = await pool.connect();
  try {
    const result = await client.query('SELECT * FROM users');
    return result.rows;
  } finally {
    client.release();
  }
};

const createUser = async (name, email) => {
  const client = await pool.connect();
  try {
    await client.query('INSERT INTO users (name, email) VALUES ($1, $2)', [name, email]);
  } finally {
    client.release();
  }
};

// 其他数据库操作函数...

module.exports = {
  getUsers,
  createUser,
  // 其他导出的函数...
};

const db = require('./db');

// 使用导出的函数进行数据库操作
db.getUsers()
  .then(users => console.log(users))
  .catch(error => console.error(error));

db.createUser('John Doe', 'john@example.com')
  .then(() => console.log('User created'))
  .catch(error => console.error(error));

// 其他数据库操作...