是否使用node获取特定Postgres数据库中的所有表？

npm install pg

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

// 创建数据库连接池
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432, // 默认Postgres端口号为5432
});

// 获取所有表的信息
async function getAllTables() {
  const client = await pool.connect();
  try {
    const result = await client.query(`
      SELECT table_name
      FROM information_schema.tables
      WHERE table_schema = 'public'
      ORDER BY table_name;
    `);
    return result.rows.map(row => row.table_name);
  } finally {
    client.release();
  }
}

// 调用函数获取所有表的信息
getAllTables()
  .then(tables => {
    console.log('所有表:', tables);
  })
  .catch(error => {
    console.error('获取表信息时出错:', error);
  });