Breaking News: Grepper is joining You.com. Read the official announcement!

postgresql with node js

YOU.com answered on September 8, 2020 Popularity 9/10 Helpfulness 3/10

answer postgresql with node js

postgresql with node js

Comment

-1

const { Pool } = require('pg');

// Create a new pool instance with the database connection details
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: your_port,
});

// Example query
const query = 'SELECT * FROM your_table';

// Use pool.query() to execute the query
pool.query(query, (err, res) => {
  if (err) {
    console.error('Error executing query', err);
  } else {
    // Process the result
    console.log(res.rows);
  }
  
  // Close the pool connection
  pool.end();
});

Popularity 9/10 Helpfulness 3/10 Language javascript

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

node js postgresql query

Comment

// callback
client.query('SELECT NOW() as now', (err, res) => {
  if (err) {
    console.log(err.stack)
  } else {
    console.log(res.rows[0])
  }
})
// promise
client
  .query('SELECT NOW() as now')
  .then(res => console.log(res.rows[0]))
  .catch(e => console.error(e.stack))

Popularity 10/10 Helpfulness 2/10 Language javascript

Source: node-postgres.com

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on May 05 2021

Zealous Zebra

0 Answers Avg Quality 2/10

postgresql nodejs

Comment

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()})()

Popularity 10/10 Helpfulness 1/10 Language javascript

Source: node-postgres.com

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on Sep 08 2020

Shy Seal

0 Answers Avg Quality 2/10

postgresql with node js

Contents

More Related Answers

postgresql with node js

Closely Related Answers

node js postgresql query

postgresql nodejs

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.