Question

How to use PostgreSQL INSERT INTO with Node.js and Express

Answer 1

const express = require('express');

const router = express.Router();

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

 router.post(
  '/',
  async (req, res) => {
    let user = ({
      first_name,
      last_name,
      email,
    } = req.body);
    try {
           const newUser = await pool.query(
              'INSERT INTO users (first_name, last_name, email) VALUES($1, $2, $3)',
              [user.first_name, user.last_name, user.email]
           );
           return res.json(newUser);
     } catch (err) {
        console.error(err.massage);
        res.status(500).send('Server error');
    }
  }
);

 

70+ SQL courses for beginners and professionals