remote_pg_connection.js

const pg = require('pg');
try {
  //in secret.js add the following
  //process.env.DATABASE_URL = 'YOUR_SECURE_REMOTE_CONNECTION_STRING';
  //ADD secret.js to your .gitignore for security
  require('./secret');
}
catch(ex){
  console.log(ex);
}

let config = {
  connectionString: 'YOUR_LOCAL_CONNECTION_STRING'
};

if(process.env.DATABASE_URL){
  config = {
    connectionString: process.env.DATABASE_URL,
    ssl: {
      rejectUnauthorized: false
    }
  };
}

const client = new pg.Client(config);
client.connect();


const setup = async()=> {
  let SQL = `
    DROP TABLE IF EXISTS users;
    CREATE TABLE users(
      id SERIAL PRIMARY KEY,
      name VARCHAR(10)
    );
  `;
  //create table
  await client.query(SQL);
  SQL = `SELECT * FROM users;`;
  let response = await client.query(SQL);
  console.log(response.rows);
  SQL = `
    INSERT INTO users(name) VALUES('moe');
    INSERT INTO users(name) VALUES('larry');
    INSERT INTO users(name) VALUES('curly');
    INSERT INTO users(name) VALUES('ethyl');
  `;
  await client.query(SQL);
  SQL = `SELECT * FROM users;`;
  response = await client.query(SQL);
  console.log(response.rows);
};

setup();