/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

1 vote313 views1 answer
Get lines as list from file node js
Javascript Node.js
-1 vote355 views1 answer
Mysql node js github
Javascript Node.js
49 votes404 views6 answers
Node random string
Javascript Node.js
0 vote324 views1 answer
How to create an async function from a string in node js
Javascript Node.js
0 vote310 views1 answer
Which is more popular nodejs or django
Javascript Node.js
1 vote298 views1 answer
Save text to file nodejs
Javascript Node.js
0 vote357 views2 answers
S3.getobject nodejs example
Javascript Node.js
21 votes345 views2 answers
Nodejs check if file is running on server or client
Javascript Node.js
19 votes343 views2 answers
Node fetch response body
Javascript Node.js
0 vote323 views2 answers
Nodejs print variable in string
Javascript Node.js