var pg = require('pg');

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 COUNT(*) FROM Hotels;', function (err, result) {
    if (err) throw err;
    console.log(result.rows[0]);
    client.end(function (err) {
      if (err) throw err;
    });
  });
});

// call it like this: PGUSER=booking PGPASSWORD=booking PGHOST=localhost PGPORT=15432 PGDATABASE=booking node connect.js