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 6C284D1E900; Thu, 22 Jan 2004 16:32:47 +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 08517-05; Thu, 22 Jan 2004 12:32:15 -0400 (AST) Received: from sycorax.affordablehost.com (sycorax.affordablehost.com [216.46.192.84]) by svr1.postgresql.org (Postfix) with ESMTP id 2DA11D1E907; Thu, 22 Jan 2004 12:32:15 -0400 (AST) Received: from h0040054d8ee4.ne.client2.attbi.com ([66.31.57.228] helo=ares.com) by sycorax.affordablehost.com with asmtp (TLSv1:RC4-MD5:128) (Exim 4.24) id 1AjhkL-0001Fk-D8; Thu, 22 Jan 2004 11:31:57 -0500 Message-ID: <400FFAF0.4050705@ares.com> Date: Thu, 22 Jan 2004 11:31:44 -0500 From: Rita Rossinelli-Biagioni User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5a) Gecko/20030718 X-Accept-Language: en-us, en, it, it-ch, fr-fr, fr-ch, de-de, de-ch 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=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sycorax.affordablehost.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - ares.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/228 X-Sequence-Number: 12091 http://freshmeat.net/projects/postgresql_autodoc/?topic_id=66 Postgresql AutoDoc - Default branch by Rod Taylor - Thursday, July 19th 2001 11:15 PST Section: Software About: Postgresql AutoDoc has the ability to output XML, which can be loaded into Dia to create a UML diagram of the database (complete with table relations and descriptive information), an HTML form for further detailed information, GraphViz .dot output, and Docbook 4.1 style SGML for inclusion with project documentation as an appendix. It works on any 7.x PostgreSQL-based database. 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) > > >