index.js

var express = require('express');
var app = express();
var cool = require('cool-ascii-faces');
var pg = require('pg');

app.set('port', (process.env.PORT || 5000));

app.use(express.static(__dirname + '/public'));

// views is directory for all template files
app.set('views', __dirname + '/views');
app.set('view engine', 'ejs');

app.get('/', function(request, response) {
    var result='';
    var times = process.env.TIMES || 5;
    for(var i=0; i<times; i++) {
        result += cool() + "  ";
    }
    response.send(result);
    // response.render('pages/index')
});

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

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});
            }
        });
    }); 
});