connect postgresql to node js code example

Example 1: postgresql nodejs

//connect to postgres database in node

const Pool = require('pg').Pool;

const pool = new Pool({
    user: '',
    host: 'localhost',
    database:  '',
    password: '',
    port:5432,
  })

//query example

app.get('/users',async(req,res)=>{
  
  try{
     let resp=await pool.query('SELECT * FROM users');
  }catch(err){
     res.status(200).send(resp.rows);
  }
})

Example 2: how to connect next js with postgresql localhost

const pgp = require('pg-promise')();

// Get the values for these variables from configuration
const user = ...
const password = ...
const host = ...
const port = ...
const database = ...

const db = pgp(`postgres://${user}:${password}@${host}:${port}/${database}`)

Example 3: postgresql nodejs

const { Client } = require('pg')const client = new Client();(async () => {  await client.connect()  const res = await client.query('SELECT $1::text as message', ['Hello world!'])  console.log(res.rows[0].message) // Hello world!  await client.end()})()