X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id AAE29D1D179
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 20 Jan 2004 07:00:37 +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 45195-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 20 Jan 2004 03:00:07 -0400 (AST)
Received: from ns.tirupati.biz (unknown [64.239.5.38])
	by svr1.postgresql.org (Postfix) with SMTP id 4F1EDD1D282
	for <pgsql-sql@postgresql.org>; Tue, 20 Jan 2004 03:00:04 -0400 (AST)
Received: (qmail 27506 invoked from network); 20 Jan 2004 07:59:01 -0000
Received: from softdnserror (HELO server2k) (61.11.69.182)
	by ns.tirupati.biz with SMTP; 20 Jan 2004 07:59:01 -0000
Received: from 192.168.50.15 by server2k ([192.168.50.102] running VPOP3) with
	SMTP for <pgsql-sql@postgresql.org>; Tue, 20 Jan 2004 12:35:12 +0530
X-MSReally-From: sqllist@coralindia.com
Message-ID: <005c01c3df23$2b58dfc0$0f32a8c0@denisnew>
From: "Denis" <sqllist@coralindia.com>
To: <pgsql-sql@postgresql.org>
References: <200401200638.i0K6caI4007124@magnusquest.com>
Subject: Re: Database diagram
Date: Tue, 20 Jan 2004 12:31:02 +0530
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Server: VPOP3 V1.5.0 - Registered
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=4.2 tagged_above=0.0 required=5.0
	tests=ORIGINAL_MESSAGE, QUOTED_EMAIL_TEXT, RCVD_IN_DSBL, RCVD_IN_NJABL,
	REFERENCES
X-Spam-Level: ****
X-Archive-Number: 200401/173
X-Sequence-Number: 16566


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