Thread: Database diagram

Database diagram

From
"Ganesan Kanavathy"
Date:
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




Re: Database diagram

From
"Denis"
Date:
Hi Ganesan,

You can try ERWin (by CA).

It creates Logical data model of the database. (though.. i haven't used
it..)

HTH

Thanx

Denis

----- Original Message -----
From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Tuesday, January 20, 2004 12:08 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




Re: Database diagram

From
Roberto Mello
Date:
On Tue, Jan 20, 2004 at 02:38:12PM +0800, Ganesan Kanavathy wrote:
> 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?

There are several such tools:

http://www.rbt.ca/autodoc/
dbVisualizer - gratis, but not Free

and many others. Search in freshmeat.net and google.

-Roberto

--
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
Veni, Vidi, VCR - I came, I saw, I videotaped it

Re: Database diagram

From
"Gregory S. Williamson"
Date:
ERWin is likely to be expensive, judging by the cost for an Informix license. It is also a serious tool; has its quirks
butcan be used to reverse engineer as well as define a database with detailed support for triggers and the like. 

Greg Williamson
DBA
GlobeXplorer LLC


-----Original Message-----
From:    Denis [mailto:sqllist@coralindia.com]
Sent:    Mon 1/19/2004 11:01 PM
To:    pgsql-sql@postgresql.org
Cc:
Subject:    Re: [SQL] Database diagram


Hi Ganesan,

You can try ERWin (by CA).

It creates Logical data model of the database. (though.. i haven't used
it..)

HTH

Thanx

Denis

----- Original Message -----
From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Tuesday, January 20, 2004 12:08 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 3: if posting/reading through Usenet, please send an appropriate     subscribe-nomail command to
majordomo@postgresql.orgso that your     message can get through to the mailing list cleanly 





Re: Database diagram

From
Luis Sousa
Date:
Ganesan Kanavathy wrote:

>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
>
>
>
>
Did you already tried dia?
I never used it, but someone told me that imports data definition from
PostgreSQL. You can try it.

Luis Sousa

Re: Database diagram

From
"Chris Travers"
Date:
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
>
>


Re: [ADMIN] Database diagram

From
Rajesh Kumar Mallah
Date:
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)
>
>
>