/Javascript/Node.js/Nodejs postgresql local connection

Nodejs postgresql local connection

const pgp = require('pg-promise')(/* initialization options */);

const cn = {
    host: 'localhost', // server name or IP address;
    port: 5432,
    database: 'myDatabase',
    user: 'myUser',
    password: 'myPassword'
};

// alternative:
// var cn = 'postgres://username:password@host:port/database';

const db = pgp(cn); // database instance;

// select and return a single user name from id:
db.one('SELECT name FROM users WHERE id = $1', [123])
    .then(user => {
        console.log(user.name); // print user name;
    })
    .catch(error => {
        console.log(error); // print the error;
    });

// alternative - new ES7 syntax with 'await':
// await db.one('SELECT name FROM users WHERE id = $1', [123]);

Source: stackoverflow.com

Similar codes

0 vote153 views1 answer
Nodejs - non-flowing data stream
Javascript Node.js
2 votes156 views2 answers
Node : The term 'node' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
Javascript Node.js
3 votes156 views1 answer
Node js request async await
Javascript Node.js
0 vote150 views1 answer
Image downloader extension in nodejs
Javascript Node.js
0 vote159 views1 answer
Openseamap nodejs github
Javascript Node.js
0 vote212 views1 answer
Start and Daemonize any application nodejs
Javascript Node.js
19 votes163 views2 answers
Node fetch response body
Javascript Node.js
20 votes167 views4 answers
Node open file
Javascript Node.js
17 votes155 views3 answers
Read json file node js
Javascript Node.js
3 votes121 views1 answer
Node cwd
Javascript Node.js