Get graphviz from:
http://www.graphviz.org/
I actually used the SuSE 9.1 RPM.
Get postgresql_autodoc from:
https://github.com/cbbrowne/autodoc
Create a database containing want you want to diagram.
createdb oacs_5_kernel
createlang plpgsql oacs_5_kernel
psql oacs_5_kernel < ./acs-kernel-create.sql
Use postgresql_autodoc to generate documentation files in html, dia, dot, and xml formats.
postgresql_autodoc -d oacs_5_kernel -f oacs_5_kernel
Use the graphviz dot command to convert the dot file into png and ps files.
dot -Tpng -o oacs_5_kernel.png oacs_5_kernel.dot
dot -Tps -o oacs_5_kernel.ps oacs_5_kernel.dot
Used Adobe Photoshop to convert the ps file to pdf. Other utilities like ps2pdf and Adobe distiller truncated the diagram. I don't know why.
I just uploaded the postgresql_autodoc html file to:
https://openacs.org/storage/download/oacs_5_kernel.html?version_id=199144
George Essig
