psqlparse.js

#!/usr/bin/env node

const url = require('url');

const parse = (connectionString) => {
  if (!connectionString) {
    return 'Connection string is needed';
  }

  const parsed = url.parse(connectionString);
  const result = ['psql'];

  if (parsed.auth) {
    const [userName, password] = parsed.auth.split(':');
    result.unshift(`PGPASSWORD=${password}`);
    result.push('-w');
    result.push(`-U ${userName}`);
  }
  if (parsed.port) {
    result.push(`-p ${parsed.port}`);
  }
  if (parsed.hostname) {
    result.push(`-h ${parsed.hostname}`);
  }
  if (parsed.pathname) {
    result.push(parsed.pathname.slice(1));
  }

  return result.join(' ');
};

console.log(parse(process.argv[2]));