Hello!

I have dumped a database. Is there a way to reverse engineer the dump
into an schema?

What I need to have is the Entity-Relationship diagram from that dump
which I can create with pg_dump databasename.

Any hints to anything welcome. Maybe is there a theoretic method which
gives a way to easier success which I don't know?

Any ideas, thoughts, book recommendations or sw welcome.

Regards,
Robert

Robert Welz schrieb:
Have you looked at the commandline options of pg_dump???

-> --schema-only

pg_dump will only dump the scheme if you supply the right argument:-)

If you want the ER diagram you don't need pg_dump at all, what you need
is some db designer that includes reverse engineer features

Toad Data Modeler for example can create the ER Diagram from a postgresql db

Stefan Braumeister <sbraumi (AT) gmx (DOT) net> wrote:

Despite not everyone uses Windows, I loaded down and will test it,
thanks for the help.


Merry christmas,

Robert Welz

Stefan Braumeister <sbraumi (AT) gmx (DOT) net> schrieb:
Maybe SquirrelSQL is also an option for you :-)

http://squirrel-sql.sourceforge.net/

It also supports reverse engineering of ER diagrams.

Best regards
Marc Schöchlin