From: Barbara Stephenson <barbara@turbocorp.com>
To: pgsql-admin@postgresql.org
Subject: Re: open source ERD for postgresql database
Date: Mon, 15 Sep 2008 15:34:56 -0400
User-Agent: KMail/1.7.1
Cc: "Anibal David Acosta" <aa@personal.net.py>,
	"'Carol Walter'" <walterc@indiana.edu>,
	"'Thomas Jacob'" <jacob@internet24.de>
References: <200809120959.15153.barbara@turbocorp.com>
	<B641E7AA-071C-4376-BA98-5E226311CC2B@indiana.edu>
	<001201c91766$32f77130$98e65390$@net.py>
In-Reply-To: <001201c91766$32f77130$98e65390$@net.py>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200809151534.56442.barbara@turbocorp.com>

Thank you all for your input.  Yes I would like to get an ERD for an existing 
system plus to create a new system.

All the ones recommended are any of them for Linux.  Our database resides on 
Redhat 4.  I prefer free/open source so I can at least take a look to see if 
it's user friendly.  However, I know some do have a 30 day trial.

Barbara

Anibal David Acosta wrote:
> 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

-- 
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