Create a new PostgreSQL database and user for local development

create_db_user.sh

#!/usr/bin/env bash
# Create a postgres database, user, and password for a local dev app

psql << EOF
    CREATE DATABASE $1;
    CREATE USER $1 WITH PASSWORD '$1';
    ALTER ROLE $1 SET client_encoding to 'utf8';
    ALTER ROLE $1 SET default_transaction_isolation TO 'read committed';
    ALTER ROLE $1 SET timezone to 'UTC';
    GRANT ALL PRIVILEGES on DATABASE $1 to $1;
EOF