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 5DA97D1D17D for ; Mon, 26 Jan 2004 11:03:50 +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 06842-08 for ; Mon, 26 Jan 2004 07:03:21 -0400 (AST) Received: from noon.pghoster.com (noon.pghoster.com [64.246.0.64]) by svr1.postgresql.org (Postfix) with ESMTP id BBD27D1B43F for ; Mon, 26 Jan 2004 07:03:17 -0400 (AST) Received: from [61.5.68.213] (helo=winxp) by noon.pghoster.com with asmtp (Exim 4.24) id 1Al4WV-0005gC-BK; Mon, 26 Jan 2004 05:03:20 -0600 Message-ID: <00be01c3e3fb$facf4550$a8285e3d@winxp> From: "Chris Travers" To: "Gary Stainburn" , References: <200401200638.i0K6caI4007124@magnusquest.com> <01f501c3e0cc$19defc20$bf285e3d@winxp> <401164FE.4060604@trade-india.com> <200401261050.48112.gary.stainburn@ringways.co.uk> Subject: Re: [SQL] Database diagram Date: Mon, 26 Jan 2004 18:02:59 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - noon.pghoster.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - travelamericas.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/208 X-Sequence-Number: 12071 Sorry, it is called postgresql_autodoc. It can be found at http://freshmeat.net/projects/postgresql_autodoc, iirc. I have been having trouble with it crashing (segfault) which is surprising since it is written in Perl (must be a bum CPAN module, but I will have to wait to figure out which one). Best Wishes, Chris Travers ----- Original Message ----- From: "Gary Stainburn" To: Sent: Monday, January 26, 2004 5:50 PM Subject: Re: [ADMIN] [SQL] Database diagram On Friday 23 January 2004 6:16 pm, Rajesh Kumar Mallah wrote: > Dear Ganesan, > > pgautodoc (for dot output) + dot (from graphviz.org , creates > postscript) + > epssplit ( splits the postscript into multipage so that one can create > poster size > diagrams) works well for me. > > I have 45 tables in the database though. Can anyone point me to a download for pgautodoc. I had a look on freshmeat (as Chris suggested) and couldn't find it. The only other thing I could find were RPMS that wouldn't go on my system. Gary > > > Regds > mallah. > > Chris Travers wrote: > >There is a free Perl script which is called something like pgautodoc which > >creates DIA diagrams from databases. Take a look for it on Freshmeat. > >----- Original Message ----- [snip] -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly