Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B94F264FCF9 for ; Tue, 16 Sep 2008 06:04:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83278-06 for ; Tue, 16 Sep 2008 06:04:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailout02.ims-firmen.de (mailout02.ims-firmen.de [213.174.32.97]) by postgresql.org (Postfix) with ESMTP id E23AE64FCBA for ; Tue, 16 Sep 2008 06:04:38 -0300 (ADT) Received: from mailin04.ims-firmen.de ([192.168.1.113]) by mailout02.ims-firmen.de with esmtp (Exim 4.69) (envelope-from ) id 1KfWTt-0004EM-GF; Tue, 16 Sep 2008 11:04:21 +0200 Received: from [213.174.32.254] (helo=[192.168.0.170]) by mailin04.ims-firmen.de with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1KfWTt-0001nY-FS; Tue, 16 Sep 2008 11:04:21 +0200 Subject: Re: open source ERD for postgresql database From: Thomas Jacob To: Anibal David Acosta Cc: 'Carol Walter' , 'Barbara Stephenson' , pgsql-admin@postgresql.org In-Reply-To: <001201c91766$32f77130$98e65390$@net.py> References: <200809120959.15153.barbara@turbocorp.com> <1221229441.1378.5.camel@enterprise.ims-firmen.de> <001201c91766$32f77130$98e65390$@net.py> Content-Type: text/plain Date: Tue, 16 Sep 2008 11:04:15 +0200 Message-Id: <1221555855.31462.1.camel@enterprise.ims-firmen.de> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 Content-Transfer-Encoding: 7bit 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: 200809/156 X-Sequence-Number: 30249 Looks interesting, how well does MICRO-OLAP support the full range of PostgreSQL's types? Things like "cidr" for instance. On Mon, 2008-09-15 at 15:06 -0400, 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 > >> > >