db.js

require('dotenv').config();

const pgp = require('pg-promise')(/* initialization options */);

const cn = {
    host: process.env.host,
    port: 5432,
    database: process.env.database,
    user: process.env.user,
    password: process.env.password
};
const db = pgp(cn); // database instance;


module.exports = db;