Skip to content

Instantly share code, notes, and snippets.

@samuelsharaf
Created July 25, 2017 06:26
Show Gist options
  • Save samuelsharaf/a81d59e2276bb95c639cc6aa649908f4 to your computer and use it in GitHub Desktop.
Save samuelsharaf/a81d59e2276bb95c639cc6aa649908f4 to your computer and use it in GitHub Desktop.
var pg = require('pg');
app.get('/db', function (request, response) {
pg.connect(process.env.DATABASE_URL, function(err, client, done) {
client.query('SELECT * FROM test_table', function(err, result) {
done();
if (err)
{ console.error(err); response.send("Error " + err); }
else
{ response.render('pages/db', {results: result.rows} ); }
});
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment