Draw Model from existing DB

Lists: pgsql-general
From: ssylla <stefansylla(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Draw Model from existing DB
Date: 2012-07-06 03:28:41
Message-ID: 1341545321358-5715605.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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.


From: Robert Gravsjö <robert(dot)gravsjo(at)imano(dot)se>
To: ssylla <stefansylla(at)gmx(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Draw Model from existing DB
Date: 2012-07-06 07:04:05
Message-ID: 5F1E8356391AA64B90E486E93546099CBD6E@IMANEXCH01.imano.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

> 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

>
> 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(at)postgresql(dot)org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general