Question

How to use PostgreSQL SELECT FROM with Node.js

Answer 1

const { Pool } = require("pg"); // npm i pg
 
const pool = new Pool({
  user: "postgres",
  password: "your_password",
  host: "localhost",
  port: 5432,
  database: "your_database_name",
});
 
module.exports = pool;

const user = await pool.query(
      'SELECT first_name, last_name FROM users WHERE id=$1',
      [id]
    );

 

70+ SQL courses for beginners and professionals