Re: open source ERD for postgresql database

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