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(at)postgresql(dot)org
>> [mailto:pgsql-admin-owner(at)postgresql(dot)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(at)postgresql(dot)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(at)turbocorp(dot)com
>>>> www.ohlogistics.com
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)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(at)turbocorp(dot)com
> www.ohlogistics.com
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin