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 6A764D1E3F3 for ; Fri, 23 Jan 2004 18:17:04 +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 17498-01 for ; Fri, 23 Jan 2004 14:16:32 -0400 (AST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 3DD28D1CB22 for ; Fri, 23 Jan 2004 14:16:31 -0400 (AST) Received: (qmail 11176 invoked from network); 23 Jan 2004 18:16:03 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 23 Jan 2004 18:16:03 -0000 Message-ID: <401164FE.4060604@trade-india.com> Date: Fri, 23 Jan 2004 23:46:30 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Chris Travers Cc: Ganesan Kanavathy , pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Database diagram References: <200401200638.i0K6caI4007124@magnusquest.com> <01f501c3e0cc$19defc20$bf285e3d@winxp> In-Reply-To: <01f501c3e0cc$19defc20$bf285e3d@winxp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/180 X-Sequence-Number: 12043 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. 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 ----- >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 >> >> >> >> > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > >