如何从Express REST API查询Postgres表中的JSON

npx express-generator myapp
cd myapp
npm install

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端口
});

// 在需要的路由中使用pool.query执行查询

const express = require('express');
const router = express.Router();

router.get('/json', async (req, res) => {
  try {
    const query = 'SELECT * FROM your_table';
    const result = await pool.query(query);
    res.json(result.rows);
  } catch (error) {
    console.error(error);
    res.status(500).json({ error: 'Internal Server Error' });
  }
});

module.exports = router;

const jsonQueryRouter = require('./routes/jsonQuery');
app.use('/api', jsonQueryRouter);

npm start