Received: from relay01.esat.net (relay01.esat.net [192.111.39.11]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA32536 for ; Mon, 26 Jul 1999 07:34:22 -0400 (EDT) (envelope-from jreynolds@asitatech.ie) Received: from (office.asitatech.ie) [193.120.140.249] by relay01.esat.net with smtp id 118j1Q-0003z6-00; Mon, 26 Jul 1999 12:34:20 +0100 Received: from [192.168.127.143] (HELO asitatech.ie) by office.asitatech.ie (AltaVista Mail V2.0/2.0 BL23 listener) id 0000_0041_379c_47ae_179b; Mon, 26 Jul 1999 12:34:06 +0100 Sender: johnr Message-ID: <379C453B.4AB8985E@asitatech.ie> Date: Mon, 26 Jul 1999 12:23:39 +0100 From: John Reynolds Organization: Asita Technologies International Ltd. X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.0.37 i586) X-Accept-Language: en MIME-Version: 1.0 CC: "'GrooveRipper@bogusart.com'" , "'pgsql-sql@postgresql.org'" Subject: Re: [SQL] RE: Tool for generating entity relation diagrams. References: <1BF7C7482189D211B03F00805F8527F70ED070@S-NATH-EXCH2> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You could try TCM ftp://ftp.cs.vu.nl/pub/tcm . I ain't had the to use it but it seems to be good john "Ansley, Michael" wrote: > >> Is there such a tool out there. I would like to generate such a diagram > >> starting from my sql statements I use to create my database. > >> They call it reverse enginering if I'm not mistaking. > > Yes, there are tools available to do this. I'm not aware of any adequate > open source tools (scope for a new project here), but commercially there are > packages like ERWin, ERStudio, and others. If you perform a web search on > these two names, you will probably come up with others. Be warned, however, > they are not cheap. > > MikeA -- ============================================================================== "There are no kernel hackers in Ireland. They spend all their time in the pub" Alan Cox ==============================================================================