Last week, I would like to see the DB of OpenERP visually. Here are the steps to achieve that. The same steps can be used to DB Diagram for Postgres DB.
Step 1: Install required modules
sudo apt-get install postgresql_autodoc graphviz
The websites for the above tools are
Step 2: Create Dot Files. The following create lots of files but we need only the dot files to create png file.
postgresql_autodoc -h localhost -d openerp -u openerp --password=abc
Step 3: Create PNG Files
dot -Tpng openerp.dot > openerp.png
That’s it. You will have the complete DB Structure.