Retrieve connection info from PostgreSQL connection string

pg_connstr_regex.sh

#!/bin/bash

str='postgresql://dbri@cxlitstaget01:5432/cxlimq_bm'
str='postgresql://dbir@cxlitstage01/cxlimq_bm'
str='postgresql://cxlitstage01:5432/cxlimq_bm'

regex='postgresql://(.*)@(.*):([0-9]*)/(.*)'
[[ $str =~ $regex ]]

if [ "$str" = "${BASH_REMATCH[0]}" ]; then
        echo "MATCH: ${BASH_REMATCH[0]}"
        echo "PGUSER: ${BASH_REMATCH[1]}"
        echo "PGHOST: ${BASH_REMATCH[2]}"
        echo "PGPORT: ${BASH_REMATCH[3]}"
        echo "PGDATABASE: ${BASH_REMATCH[4]}"
fi

regex='postgresql://(.*)@(.*)/(.*)'
[[ $str =~ $regex ]]

if [ "$str" = "${BASH_REMATCH[0]}" ]; then
        echo "MATCH: ${BASH_REMATCH[0]}"
        echo "PGUSER: ${BASH_REMATCH[1]}"
        echo "PGHOST: ${BASH_REMATCH[2]}"
        echo "PGPORT: (not found) 5432"
        echo "PGDATABASE: ${BASH_REMATCH[3]}"
fi

regex='postgresql://(.*)/(.*)'
[[ $str =~ $regex ]]

if [ "$str" = "${BASH_REMATCH[0]}" ]; then
        echo "MATCH: ${BASH_REMATCH[0]}"
        echo "PGUSER: (not found) (not set)"
        echo "PGHOST: ${BASH_REMATCH[1]}"
        echo "PGPORT: (not found) (5432)"
        echo "PGDATABASE: ${BASH_REMATCH[2]}"
fi

regex='postgresql://(.*):([0-9]*)/(.*)'
[[ $str =~ $regex ]]

if [ "$str" = "${BASH_REMATCH[0]}" ]; then
        echo "MATCH: ${BASH_REMATCH[0]}"
        echo "PGUSER: (not found) (not set)"
        echo "PGHOST: ${BASH_REMATCH[1]}"
        echo "PGPORT: ${BASH_REMATCH[2]}"
        echo "PGDATABASE: ${BASH_REMATCH[3]}"
fi