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@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxx > >> www.ohlogistics.com > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > 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@xxxxxxxxxxxxx www.ohlogistics.com
