Draw Model from existing DB

Started by ssyllaalmost 14 years ago2 messagesgeneral
Jump to latest
#1ssylla
stefansylla@gmx.de

Dear list,

I have an existing PostgreSQL DB and I would like to draw a model of the DB
structure. Is there some software (Freeware) around that can read the
existing structure of my DB and automatically draw e.g. an ER-model of that?
The software that I have found so far (e.g. Open System Architect) seems to
be able to build models from scratch and convert them into a DB, but not the
other way around like what I need.

Best-
Stefan

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Draw-Model-from-existing-DB-tp5715605.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

#2Robert Gravsjö
robert.gravsjo@imano.se
In reply to: ssylla (#1)
Re: Draw Model from existing DB

I have an existing PostgreSQL DB and I would like to draw a model of the DB
structure. Is there some software (Freeware) around that can read the
existing structure of my DB and automatically draw e.g. an ER-model of that?
The software that I have found so far (e.g. Open System Architect) seems to
be able to build models from scratch and convert them into a DB, but not the
other way around like what I need.

I have found SQL Power Architect to work pretty nice in some situation. To get a model you simply create a new source connection to your db, connect to it and drag and drop it on to the playpen area (the right hand side in the UI).

There's both a community edition and a commercial edition. Project page is http://code.google.com/p/power-architect/

Regards
roppert

Show quoted text

Best-
Stefan

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Draw-Model-from-existing-DB-
tp5715605.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general