node+postgres sample

gistfile1.js

var pg = require('pg');
var dbuser ="userid:password";
var dbsrv = "localhost:5432";
var db = "postgres";

var conString = "pg://" + dbuser + "@" + dbsrv + "/" + db ;

pg.connect(conString, function(err, client) {
  client.query("SELECT NOW() as when" ,function(err,result) {
    console.log("Row count: %d", result.rows.length);
    console.log("Current year %d", result.rows[0].when.getYear());
  });
});
pg.end();