Postgres fast and secure user creation script. Usage: pgsqlcreateuser <username> [dbname] Prints generated password.

pgsqlcreateuser.sh

#!/bin/bash

pg_pw=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1)
sudo su postgres -c "psql -c \"DO \\$\\$
BEGIN
IF EXISTS (SELECT FROM pg_roles WHERE rolname='$1') THEN
  ALTER ROLE $1 WITH PASSWORD '$pg_pw';
ELSE
  CREATE USER $1 WITH PASSWORD '$pg_pw';
END IF;
END \\$\\$;\"; $([ -z "$2" ] && echo "" || echo "createdb $2")"
echo "The generated password for $1 is:"
echo $pg_pw