From: Anibal David Acosta <aa@personal.net.py>
To: 'Carol Walter' <walterc@indiana.edu>
To: 'Thomas Jacob' <jacob@internet24.de>
Cc: 'Barbara Stephenson' <barbara@turbocorp.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: open source ERD for postgresql database
Date: Mon, 15 Sep 2008 15:06:43 -0400
Message-ID: <001201c91766$32f77130$98e65390$@net.py> (raw)
In-Reply-To: <B641E7AA-071C-4376-BA98-5E226311CC2B@indiana.edu>
References: <200809120959.15153.barbara@turbocorp.com>
<1221229441.1378.5.camel@enterprise.ims-firmen.de>
<B641E7AA-071C-4376-BA98-5E226311CC2B@indiana.edu>
MICRO-OLAP Database designer for postgres is a great tool.
-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] En nombre de Carol Walter
Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m.
Para: Thomas Jacob
CC: Barbara Stephenson; pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] open source ERD for postgresql database
This sort of depends on what you want to do with the ERD. If I want
to document an existing system, I use Aqua Data Studio. It's not
free, but it will take an existing system and draw the ERD for you
based on the relationships it finds in the database. There are
things that I don't like about it. It puts the tables into the ERD
in alpha order. This leads to some spaghetti ERD's. You can move
the tables around and then save them. The problem is that once they
are saved, it's an image and you can't move them anymore. If you
recreate the ERD you have to begin again to move the tables around.
Another tool that some people like, but that I haven't used is called
SQL-EZ. It's cost is trivial.
Carol
On Sep 12, 2008, at 10:24 AM, Thomas Jacob wrote:
> I've been using GNU ferret for a while, it's OK
> for simple tasks, and can produce table graphs and
> even output rudimentary PostgreSQL DDL in Version 0.6,
> but it doesn't support PostgreSQL's full range of types yet
> and the handling is somewhat awkward.
>
> Version 0.7 looks much more promising, at least from
> the screen shots, but that hasn't been release yet:
>
> http://www.gnuferret.org/
>
>
>
> On Fri, 2008-09-12 at 09:59 -0400, Barbara Stephenson wrote:
>> I would like to use an ERD tool for postgres and it be open
>> source. Any
>> suggestions?
>> --
>> Regards,
>>
>> Barbara Stephenson
>> EDI Specialist/Programmer
>> Turbo, division of Ozburn-Hessey Logistics
>> 2251 Jesse Jewell Pkwy NE
>> Gainesville, GA 30507
>> tel: (678)989-3020 fax: (404)935-6171
>> barbara@turbocorp.com
>> www.ohlogistics.com
>>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aa@personal.net.py, walterc@indiana.edu, jacob@internet24.de, barbara@turbocorp.com
Subject: Re: open source ERD for postgresql database
In-Reply-To: <001201c91766$32f77130$98e65390$@net.py>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox