Re: [SQL] Database diagram

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)
>
>
>