Question

How to use PostgreSQL UPDATE SET 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(
      'UPDATE profiles SET website=$1, company=$2 WHERE id=$3',
      [website, company, id]
);

 

70+ SQL courses for beginners and professionals