X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 931FC55720 for ; Thu, 24 Feb 2005 12:04:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97195-08 for ; Thu, 24 Feb 2005 12:04:17 +0000 (GMT) Received: from mx5.net.nih.gov (mx5.net.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 3432B555EF for ; Thu, 24 Feb 2005 12:04:16 +0000 (GMT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j1OC4NiU032581 for ; Thu, 24 Feb 2005 07:04:24 -0500 Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j1OC4NQO032577; Thu, 24 Feb 2005 07:04:23 -0500 In-Reply-To: <421D8DAA.3080804@archonet.com> References: <383gdaF5k6fpoU1@individual.net> <421D8DAA.3080804@archonet.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <46ba0b9b0fba6580ee3dc8e73e379598@mail.nih.gov> Content-Transfer-Encoding: 7bit Cc: pgsql-sql@postgresql.org, Kai Hessing From: Sean Davis Subject: Re: Software for database-visualisation Date: Thu, 24 Feb 2005 07:04:23 -0500 To: Richard Huxton X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/299 X-Sequence-Number: 20409 If you mean literally visualizing the ERD, you can look at SQL::Translator (on cpan) which can draw fairly complex ERDs and output as graphics (I forget the supported formats).... Sean On Feb 24, 2005, at 3:17 AM, Richard Huxton wrote: > Kai Hessing wrote: >> Another question: Which software are you using to visualize your >> database-structur. We're doing it with Quark, but are not very happy >> with this. > > Well, AutoDoc can generate HTML/Dia/other outputs > http://www.rbt.ca/autodoc/index.html > > Might be worth checking the (freely available) Red-Hat db tools. Can't > remember if there's a schema visualiser in there, but there might well > be. > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)