Script to generate DOT graph of dependencies between tables in PostgreSQL

pg_graph.sh

#!/bin/sh

psql -qX "$@" <<EOF
\t on
\timing off

\echo 'Digraph F{'
\echo 'ranksep=1.0; size="18.5, 15.5"; rankdir=LR;'

SELECT
    '"' || tc.table_name || '"->"' || ccu.table_name || '" [label="' || tc.constraint_name || '"];'
FROM
    information_schema.table_constraints AS tc
JOIN information_schema.key_column_usage AS kcu ON
    tc.constraint_name = kcu.constraint_name
JOIN information_schema.constraint_column_usage AS ccu ON
    ccu.constraint_name = tc.constraint_name
WHERE constraint_type = 'FOREIGN KEY';

\echo '}'
EOF