Re: open source ERD for postgresql database

My databases are running on top of Solaris 10, but I don't think
RedHat should be a problem.  Aqua Data Studio is one of the products
that allow you to do the trial version.

Carol

On Sep 15, 2008, at 3:34 PM, Barbara Stephenson wrote:

> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin