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