Making Database Diagrams with PostgreSQL Autodoc

http://www.rbt.ca/autodoc/index.html


postgresql_autodoc -d db_name

see dot output.
dot -Tpng -o output.png db_name.dot