Hash a role/password for a CREATE ROLE... in PostgreSQL

pg_prepare_password

#!/bin/bash

[[ $# -eq 0 ]] || {
    cat <<EOF >&2
Usage: ${0##*/}

Prompts for Role and Password and outputs the hash in the correct format for a
"CREATE ROLE ... PASSWORD 'xxx';" in PostgreSQL.

EOF
    exit 1
}

read -p 'Role: ' ROLE
read -s -p 'Password: ' PASSWORD

PREFIX=md5
HASH=$( echo -n "${PASSWORD}${ROLE}" | md5sum | cut -d ' ' -f 1 )

echo ${PREFIX}${HASH}