X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0346DD1D880 for ; Wed, 14 Jan 2004 15:55:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 42434-03 for ; Wed, 14 Jan 2004 11:55:02 -0400 (AST) Received: from ecbull20.frec.bull.fr (ecbull20.frec.bull.fr [129.183.4.3]) by svr1.postgresql.org (Postfix) with ESMTP id E1AB7D1DA6C for ; Wed, 14 Jan 2004 11:54:55 -0400 (AST) Received: from ecn002.frec.bull.fr (ecn002.frec.bull.fr [129.183.4.6]) by ecbull20.frec.bull.fr (8.9.2/8.9.1) with ESMTP id QAA14014; Wed, 14 Jan 2004 16:55:43 +0100 Received: from BULL.NET ([129.183.148.134]) by ecn002.frec.bull.fr (Lotus Domino Release 5.0.12) with ESMTP id 2004011416581826:527 ; Wed, 14 Jan 2004 16:58:18 +0100 Message-ID: <4005661E.627CBF74@BULL.NET> Date: Wed, 14 Jan 2004 16:54:06 +0100 From: Thierry Missimilly Organization: Bull Linux Center X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: fr,en MIME-Version: 1.0 To: Juan Miguel Cc: pgsql-admin@postgresql.org Subject: Re: Are there programs to graph database schema? References: <272e4be7.0401121419.37989e3a@posting.google.com> <1591904921.20040114090211@radax.net> <40054EE8.2050107@ono.com> X-MIMETrack: Itemize by SMTP Server on ECN002/FR/BULL(Release 5.0.12 |February 13, 2003) at 14/01/2004 16:58:18, Serialize by Router on ECN002/FR/BULL(Release 5.0.12 |February 13, 2003) at 14/01/2004 17:00:01, Serialize complete at 14/01/2004 17:00:01 Content-Type: multipart/mixed; boundary="------------FEAA4F6703EA37127EDCCFD8" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/118 X-Sequence-Number: 11981 This is a multi-part message in MIME format. --------------FEAA4F6703EA37127EDCCFD8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, For a small schema, i've used PGACESS. There is a graphical editor which help you to draw boxes with the foreign keys. Thierry Juan Miguel wrote: > Hi, I use MS Visio Professional, and it works (not very good), but it works. > I ever wondered if there is a opensource tool, that let me create an > automatic ER-Model diagram from an existing DB, like MS Visio. > Do you know if this tool exists ? > > Thanks > > >Hi Tony, > > > >TR> It occured to me that perhaps programs existed which simply parsed the > >TR> table definitions and plotted the graphs for you. > > > >If I need to create an [E]ER-Modell from an existing databasae, > >I mostly use MS Visio professional. It can reverse engineer via > >ODBC lots of DBS. > > > >Rico > > > > > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 4: Don't 'kill -9' the postmaster > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match --------------FEAA4F6703EA37127EDCCFD8 Content-Type: text/x-vcard; charset=us-ascii; name="THIERRY.MISSIMILLY.vcf" Content-Description: Card for Thierry Missimilly Content-Disposition: attachment; filename="THIERRY.MISSIMILLY.vcf" Content-Transfer-Encoding: 7bit begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/R&D adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:Thierry.Missimilly@bull.net x-mozilla-cpt:;-18184 fn:Thierry Missimilly end:vcard --------------FEAA4F6703EA37127EDCCFD8--