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