Autodoc - GraphViz Output

The GraphViz or Dot output has been created for GraphViz, specifically the dot utility.

Exported Details

  • Primary Key
  • Foreign Keys relating tables
  • Column Type and Default Value
  • Constraints on a column (CHECK statements)
  • Groups initially defined by constraints
  • SERIAL extraction

The primary advantage of the GraphViz output is that the dot program will automatically place the structures in reasonable locations. Dot has issues with large databases. They tend to come out looking like spaghetti.

Example 1. Running dot on the Autodoc output

Have dot create a PNG output.png based on the Autodoc output database.dot.

bash-2.05b$ dot -Tpng -o output.png database.dot

The output of the Autodoc regression database.