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 4A752D1B55F; Thu, 22 Jan 2004 09:43:48 +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 06782-10; Thu, 22 Jan 2004 05:43:19 -0400 (AST) Received: from noon.pghoster.com (noon.pghoster.com [64.246.0.64]) by svr1.postgresql.org (Postfix) with ESMTP id 2CBE8D1C9E5; Thu, 22 Jan 2004 05:43:17 -0400 (AST) Received: from [61.5.68.52] (helo=winxp) by noon.pghoster.com with asmtp (Exim 4.24) id 1AjbMr-0005sJ-Ce; Thu, 22 Jan 2004 03:43:18 -0600 Message-ID: <01f501c3e0cc$19defc20$bf285e3d@winxp> From: "Chris Travers" To: "Ganesan Kanavathy" , , References: <200401200638.i0K6caI4007124@magnusquest.com> Subject: Re: [SQL] Database diagram Date: Thu, 22 Jan 2004 15:38:31 +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/176 X-Sequence-Number: 12039 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 ----- From: "Ganesan Kanavathy" To: ; Sent: Tuesday, January 20, 2004 1:38 PM Subject: [SQL] Database diagram > I have a postgres database with many tables. > > How do I create database diagram? Are there any free tools available to > create database diagram from pgsql database? > > Regards, > Ganesan > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > >