Greetings!
pg_autodoc
http://www.rbt.ca/autodoc/index.html
can produce .dot files that can be charted using graphviz.
http://www.graphviz.org/
It works pretty well for medium sized databases but for large it tends to produce a spaghetti.
Check the "Related Sites" in graphviz.org homepage.
Regds mallah.
Hi, I use MS Visio Professional, and it works (not very good), but it works.
I ever wondered if there is a opensource tool, that let me create an automatic ER-Model diagram from an existing DB, like MS Visio.
Do you know if this tool exists ?
Thanks
Hi Tony,
TR> It occured to me that perhaps programs existed which simply parsed the
TR> table definitions and plotted the graphs for you.
If I need to create an [E]ER-Modell from an existing databasae, I mostly use MS Visio professional. It can reverse engineer via ODBC lots of DBS.
Rico
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html