ERWin is likely to be expensive, judging by the cost for an Informix license. It is also a serious tool; has its quirks but can 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:[EMAIL PROTECTED] Sent: Mon 1/19/2004 11:01 PM To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match