Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CCAF264FCF3 for ; Wed, 19 Nov 2008 16:25:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59014-06 for ; Wed, 19 Nov 2008 16:25:35 -0400 (AST) X-Greylist: delayed 00:05:01.951781 by SQLgrey-1.7.6 Received: from fmailhost04.isp.att.net (fmailhost04.isp.att.net [207.115.11.54]) by mail.postgresql.org (Postfix) with ESMTP id B1F7E64FC5A for ; Wed, 19 Nov 2008 16:25:34 -0400 (AST) Received: from [192.168.1.1] (adsl-074-232-167-068.sip.asm.bellsouth.net[74.232.167.68]) by isp.att.net (frfwmhc04) with ESMTP id <20081119201526H0400huuiqe>; Wed, 19 Nov 2008 20:15:27 +0000 X-Originating-IP: [74.232.167.68] From: Barbara Stephenson To: pgsql-admin@postgresql.org Subject: Re: open source ERD for postgresql database Date: Wed, 19 Nov 2008 15:12:18 -0500 User-Agent: KMail/1.7.1 Cc: "Anibal David Acosta" , "'Carol Walter'" , "'Thomas Jacob'" References: <200809120959.15153.barbara@turbocorp.com> <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: <200811191512.18802.barbara@turbocorp.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/117 X-Sequence-Number: 30771 Sorry just now had some time to look at this but unfortunately this is not for PG on linux. :( 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 OHL 2251 Jesse Jewell Pkwy Gainesville, GA 30507 tel: (678)989-3020 fax: (404)935-6171 barbara@turbocorp.com www.ohl.com