Skip site navigation (1) Skip section navigation (2)

Re: open source ERD for postgresql database

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Thomas Jacob <jacob(at)internet24(dot)de>
Cc: Barbara Stephenson <barbara(at)turbocorp(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: open source ERD for postgresql database
Date: 2008-09-15 18:58:02
Message-ID: B641E7AA-071C-4376-BA98-5E226311CC2B@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)turbocorp(dot)com
>> www.ohlogistics.com
>>


In response to

Responses

pgsql-admin by date

Next:From: Anibal David AcostaDate: 2008-09-15 19:06:43
Subject: Re: open source ERD for postgresql database
Previous:From: Scott MarloweDate: 2008-09-15 17:57:19
Subject: Re: [GENERAL] Functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group