Question :
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I’m looking for a simple ERD or UML class diagram in a format that is easy to work with (SVG, PDF or any common UML file format).
So far, I founded only software for MySQL and it’s for Windows,
but that’s not solution.
Answer :
Have a look at at (the order of the items implies my personal choices)
- DbSchema (not free, but not expensive: http://dbschema.com/)
- SchemaSpy (http://schemaspy.sourceforge.net/)
- Power*Architect (http://code.google.com/p/power-architect/) although development seems to have stopped)
All of them work with PostgreSQL (and other DBMS)
(Note: I have nothing to do with DbSchema. I just think it’s a pretty good tool)
pg_autodoc is what I have used. It converts to dia UML diagrams. Seems to work ok. http://www.rbt.ca/autodoc/