How to use PostgreSQL SELECT FROM with Node.js

1 Answer

0 votes
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]
    );

 



answered May 15, 2020 by avibootz

Related questions

...