Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)

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.

See: stackoverflow.com/questions/2937723/… The accepted answer runs on Linux: dbschema.com/download.html
Quite often people have Visio pro just lying around, and it's got a passably good DB reverse engineering function. May or may not be relevant to the OP but it's a good standby in many cases.
visual-paradigm has postgresql port too. www.visual-paradigm.com free version also does.

a_horse_with_no_name · Answer 1 · 2012-12-02 15:15:16Z

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)

Chris Travers · Answer 2 · 2012-09-03 09:07:00Z

up vote 0 down vote

pg_autodoc is what I have used. It converts to dia UML diagrams. Seems to work ok. http://www.rbt.ca/autodoc/

answered Sep 3 '12 at 9:07

Chris Travers
5,346431

	does this work on newer version of PostgreSQL? 8.x and above? – Phill Pafford Oct 12 '12 at 14:20
	I have used it on 7.x through 9.x. – Chris Travers Oct 12 '12 at 14:28
	That creates a table diagram. Getting from there to an entity-relationship diagram is another step. – Peter Eisentraut Jan 2 at 15:45

2 Answers