.pgpass with aliases for psql

.pgapass

alias:host:port:db:user:pass
alias2:host2:port2:db2:user2:pass2

psql

#!/usr/bin/env bash

# Create a ~/.pgapass file with lines:
# alias:host:port:db:user:pass

function usage() {
	echo 'Usage:
  psql --list|-l # Show all aliases
  psql <alias> # Connect to alias'
}

if [ ! -f /usr/bin/psql ]; then
	sudo apt install -y postgres-client
fi

if [ -z "${1}" ]; then
	usage;
fi

case "${1}" in
	--list|-l)
		if [ -f ~/.pgapass ]; then
			cat ~/.pgapass |sed 's/:.*//' |sort
		fi
		;;
	*)
		for LINE in $(cat ~/.pgapass); do
			IFS=':' read -r ALIAS HOST PORT DB U P <<< "$LINE"
			if [ "${ALIAS}" = "${1}" ]; then
				echo "${HOST}:${PORT}:${DB}:${U}:${P}" > ~/.pgpass
				chmod 600 ~/.pgpass
				shift
				PGPASSFILE=~/.pgpass /usr/bin/psql --host ${HOST} --user ${U} --port ${PORT} $@ ${DB}
				rm -f ~/.pgpass
			fi
		done
		;;
esac

Thanks! I've modified your script here: https://gist.github.com/jamesidw/0c66f5d1e78555144edb32f93b120997