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

postgresql nodejs

Shy Seal answered on September 8, 2020 Popularity 10/10 Helpfulness 1/10

answer postgresql nodejs

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 postgresql

Link to this answer
Share Copy Link

Contributed on Sep 08 2020

Shy Seal

0 Answers Avg Quality 2/10

Closely Related Answers

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

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

Contents

More Related Answers

postgresql nodejs

Closely Related Answers

postgresql with node js

node js postgresql query

Grepper

Documentation

Social

Legal

Contact

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