Generating database diagrams for schema analysis

If you want to analyse a database, understand relations between its tables etc., you can use this tool : schemaspy

Example usage:

Creating openerp database diagrams

  1. Download schemaspy from : http://sourceforge.net/projects/schemaspy/files/
  2. It used to have dependency on Graphviz, so you may also have to install graphviz : http://www.graphviz.org/Download..php
  3. command to execute the jar :

    java -jar schemaSpy_5.0.0.jar -t pgsql  -db openerp -s public -u openerp -p <password> -host <host> -o <output dir> -dp <path-to-the-db-driver>

More info on the parameters can be found at http://schemaspy.sourceforge.net/