Re: build model from existing db

Lists: pgsql-general
From: ssylla <stefansylla(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: build model from existing db
Date: 2012-07-06 03:13:56
Message-ID: 1341544436472-5715603.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/build-model-from-existing-db-tp5715603.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: ssylla <stefansylla(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: build model from existing db
Date: 2012-07-06 04:36:45
Message-ID: 4FF66B5D.5060902@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On 07/06/2012 11:13 AM, ssylla wrote:
> 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?
I use and like SchemaSpy ( http://schemaspy.sourceforge.net/).

--
Craig Ringer