mirror of
https://github.com/github/codeql.git
synced 2025-12-17 09:13:20 +01:00
27 lines
801 B
JavaScript
27 lines
801 B
JavaScript
// Adapted from the documentation of https://github.com/brianc/node-postgres,
|
|
// which is licensed under the MIT license; see file node-postgres-LICENSE.
|
|
var pg = require('pg');
|
|
|
|
// instantiate a new client
|
|
// the client will read connection information from
|
|
// the same environment variables used by postgres cli tools
|
|
var client = new pg.Client();
|
|
|
|
// connect to our database
|
|
client.connect(function (err) {
|
|
if (err) throw err;
|
|
|
|
// execute a query on our database
|
|
client.query('SELECT $1::text as name', ['brianc'], function (err, result) {
|
|
if (err) throw err;
|
|
|
|
// just print the result to the console
|
|
console.log(result.rows[0]); // outputs: { name: 'brianc' }
|
|
|
|
// disconnect the client
|
|
client.end(function (err) {
|
|
if (err) throw err;
|
|
});
|
|
});
|
|
});
|