index.js

var cool = require('cool-ascii-faces');
var express = require('express');
var pg = require('pg');
var query = require("pg-query");
var conString = process.env.DATABASE_URL || "postgres://mpjcvtjxocsmeb:gruLA0ckuOeqIRfkRyHDp9Vre9@ec2-54-204-27-193.compute-1.amazonaws.com:5432/d63j6ljg1re6ac";
var app = express();
var client = new pg.Client(conString);


app.set('port', (5023));
app.use(express.static(__dirname + '/public'));
app.set('views', __dirname + '/views');
app.set('view engine', 'ejs');



app.get('/', function (request, response) {
  response.render('pages/index')
});

app.get('/about', function (request, response) {
  response.render('pages/about')
});

app.get('/contact', function (request, response) {
  response.render('pages/contact')
});

app.get("/registro", function (request, response){
  response.render("pages/registro")
});

app.get('/db', function (request, response) {
  pg.connect(conString, function (err, client, done) {
    query('SELECT * FROM test_table', function (err, result) {
      if (err)
       { console.error(err); response.send("Error #marafaka " + err); }
      else
       { response.render('pages/db', {results: result.rows} ); };
    done();  
    });
  });
});

app.get('/cool', function (request, response) {process.env.DATABASE_URL || 
  response.send(cool());
});


app.listen(app.get('port'), function() {
  console.log('Node app is running on port', app.get('port'));
});