From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Chris Travers <chris@travelamericas.com>
Cc: Ganesan Kanavathy <ganesh@magnusquest.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database diagram
Date: Fri, 23 Jan 2004 23:46:30 +0530
Message-ID: <401164FE.4060604@trade-india.com> (raw)
In-Reply-To: <01f501c3e0cc$19defc20$bf285e3d@winxp>
References: <200401200638.i0K6caI4007124@magnusquest.com>
<01f501c3e0cc$19defc20$bf285e3d@winxp>
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" <ganesh@magnusquest.com>
>To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
>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)
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, chris@travelamericas.com, ganesh@magnusquest.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] Database diagram
In-Reply-To: <401164FE.4060604@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox