PostgreSQL dumps into DOT files or PNGs

script.sh

docker exec <database image> pg_dump -s -U <database username> <database name> | \
    # Strip out the namespace because graphviz doesn't know what to do with it
    sed 's/ public\./ /g' | \
    # Turn that thing into a DOTfile!
    docker run -i --rm mgwalker/sql_graphviz:1.0 > docs/database-diagram.dot
    
docker exec <database image> pg_dump -s -U <database username> <database name> | \
    # Strip out the namespace because sql_graphviz doesn't know what to do with it
    sed 's/ public\./ /g' | \
    # Turn that thing into a DOTfile
    docker run -i --rm mgwalker/sql_graphviz:1.0 | \
    # And then into a PNG!
    docker run -i --rm fgrehm/graphviz dot -Tpng > docs/database-diagram.png