#usage: $ create_dsn 'username' 'password' 'host'
create_dsn(){

  USER_NAME=$1
  PASSWORD=$2
  HOST=$3

  echo "CREATE DATABASE $USER_NAME;" >> "$USER_NAME.dsn"
  echo "CREATE ROLE $USER_NAME LOGIN PASSWORD '$PASSWORD';" >> "$USER_NAME.dsn"
  echo "ALTER DATABASE $USER_NAME OWNER TO $USER_NAME;" >> "$USER_NAME.dsn"

  echo "HOST: $HOST" >> "$USER_NAME.dsn"
  echo "USER: $USER_NAME" >> "$USER_NAME.dsn"
  echo "DATABASE: $USER_NAME" >> "$USER_NAME.dsn"
  echo "PASSWORD: $PASSWORD" >> "$USER_NAME.dsn"
  echo "DSN: postgres://$USER_NAME:$PASSWORD@$HOST:5432/$USER_NAME" >> "$USER_NAME.dsn"

  echo "$ PGPASSWORD='$PASSWORD' psql -U $USER_NAME -h $HOST $USER_NAME" >> "$USER_NAME.dsn"
}