Postgresql AutoDoc has the ability to output XML, which can be loaded into Dia to create a UML diagram of the database (complete with table relations and descriptive information), an HTML form for further detailed information, GraphViz .dot output, and Docbook 4.1 style SGML for inclusion with project documentation as an appendix. It works on any 7.x PostgreSQL-based database.
Release Notes: This release features lots of template enhancements and improved argument handling for multi-schema support. In the background there was a fair amount of code cleanup as well.
Release Notes: A problem where spurious duplicates appeared when columns used reserved keywords was fixed. Table comments were added to the Dia output.
Release Notes: Check constraints are now formatted correctly for Pg7.4. Functions using numeric arguments no longer cause perl to segfault. Other bugs were fixed.
Release Notes: There is a new template using ZigZag lines for UML diagrams in Dia. Permissions and reserved words in the GraphViz template have been fixed.
Release Notes: Several annoying bugs were fixed, including correcting builds with older versions of PostgreSQL (7.2 and 7.1).