如何在express js(node js)中编写postgres IN运算符查询

npm install pg

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

const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432, // 默认PostgreSQL端口号为5432
});

app.get('/data', async (req, res) => {
  try {
    const values = [1, 2, 3]; // IN运算符的参数值
    const query = 'SELECT * FROM your_table WHERE column_name IN ($1, $2, $3)';
    const result = await pool.query(query, values);
    res.json(result.rows);
  } catch (error) {
    console.error('Error executing query', error);
    res.status(500).json({ error: 'Internal server error' });
  }
});