Node PG example

node-pg-example.js

/*
 * GET home page.
 */

var pg = require('pg');

exports.index = function(req, res){

  var conString = "tcp://127.0.0.1/postgres";
  var out = "";

  client = new pg.Client(conString);
  client.connect();

  var query = client.query("SELECT NOW() as when");

  query.on('row', function(row) {
    out = row.when;
    
    console.log(out);
  });

  query.on('end', function() { 
    client.end();

    res.render('index', { title: out, envvars: process.env.VCAP_SERVICES });
    res.end();
  });

  
};