Thread: Are there programs to graph database schema?
I know that there are standard ways to graph relational databases. It occured to me that perhaps programs existed which simply parsed the table definitions and plotted the graphs for you. Anyone know of such a thing? Thanks. -Tony
Hi Tony, TR> It occured to me that perhaps programs existed which simply parsed the TR> table definitions and plotted the graphs for you. If I need to create an [E]ER-Modell from an existing databasae, I mostly use MS Visio professional. It can reverse engineer via ODBC lots of DBS. Rico
Hi, I use MS Visio Professional, and it works (not very good), but it works. I ever wondered if there is a opensource tool, that let me create an automatic ER-Model diagram from an existing DB, like MS Visio. Do you know if this tool exists ? Thanks >Hi Tony, > >TR> It occured to me that perhaps programs existed which simply parsed the >TR> table definitions and plotted the graphs for you. > >If I need to create an [E]ER-Modell from an existing databasae, >I mostly use MS Visio professional. It can reverse engineer via >ODBC lots of DBS. > >Rico > > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > >
Hi, For a small schema, i've used PGACESS. There is a graphical editor which help you to draw boxes with the foreign keys. Thierry Juan Miguel wrote: > Hi, I use MS Visio Professional, and it works (not very good), but it works. > I ever wondered if there is a opensource tool, that let me create an > automatic ER-Model diagram from an existing DB, like MS Visio. > Do you know if this tool exists ? > > Thanks > > >Hi Tony, > > > >TR> It occured to me that perhaps programs existed which simply parsed the > >TR> table definitions and plotted the graphs for you. > > > >If I need to create an [E]ER-Modell from an existing databasae, > >I mostly use MS Visio professional. It can reverse engineer via > >ODBC lots of DBS. > > > >Rico > > > > > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 4: Don't 'kill -9' the postmaster > > > > > > > > ---------------------------(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
Attachment
Guten Tag Juan Miguel, Hi Juan, JM> Hi, I use MS Visio Professional, and it works (not very good), but it works. JM> I ever wondered if there is a opensource tool, that let me create an JM> automatic ER-Model diagram from an existing DB, like MS Visio. JM> Do you know if this tool exists ? Unfortunately I don't. I am unsatisfied with Visio too, but the point of reason for using it is exactly that I don't know a better tool. If anybody does - please let me know! Rico
Juan Miguel wrote: Greetings! pg_autodoc http://www.rbt.ca/autodoc/index.html can produce .dot files that can be charted using graphviz. http://www.graphviz.org/ It works pretty well for medium sized databases but for large it tends to produce a spaghetti. Check the "Related Sites" in graphviz.org homepage. Regds mallah. > Hi, I use MS Visio Professional, and it works (not very good), but it > works. > I ever wondered if there is a opensource tool, that let me create an > automatic ER-Model diagram from an existing DB, like MS Visio. > Do you know if this tool exists ? > > Thanks > >> Hi Tony, >> >> TR> It occured to me that perhaps programs existed which simply >> parsed the >> TR> table definitions and plotted the graphs for you. >> >> If I need to create an [E]ER-Modell from an existing databasae, >> I mostly use MS Visio professional. It can reverse engineer via >> ODBC lots of DBS. >> >> Rico >> >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> >> >> > > > > ---------------------------(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 >
Hi All , Have a look at DbVisualizer-4.0.2 Java based ER tool that works very well. Regards. Leslie. On Wed, 2004-01-14 at 18:15, Enrico Ortmann wrote: > Guten Tag Juan Miguel, > > Hi Juan, > > JM> Hi, I use MS Visio Professional, and it works (not very good), but it works. > JM> I ever wondered if there is a opensource tool, that let me create an > JM> automatic ER-Model diagram from an existing DB, like MS Visio. > JM> Do you know if this tool exists ? > > Unfortunately I don't. I am unsatisfied with Visio too, but the point > of reason for using it is exactly that I don't know a better tool. > If anybody does - please let me know! > > Rico > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
We recently purchased DBVisualizer. It's really quite good for this kind of diagram (some quirks). http://www.dbvis.com It's not open source though and you do have a small charge to pay. Cheers, Hal. -----Original Message----- From: Rajesh Kumar Mallah [mailto:mallah@trade-india.com] Sent: 14 January 2004 18:26 To: Juan Miguel Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Are there programs to graph database schema? Juan Miguel wrote: Greetings! pg_autodoc http://www.rbt.ca/autodoc/index.html can produce .dot files that can be charted using graphviz. http://www.graphviz.org/ It works pretty well for medium sized databases but for large it tends to produce a spaghetti. Check the "Related Sites" in graphviz.org homepage. Regds mallah. > Hi, I use MS Visio Professional, and it works (not very good), but it > works. > I ever wondered if there is a opensource tool, that let me create an > automatic ER-Model diagram from an existing DB, like MS Visio. > Do you know if this tool exists ? > > Thanks > >> Hi Tony, >> >> TR> It occured to me that perhaps programs existed which simply >> parsed the >> TR> table definitions and plotted the graphs for you. >> >> If I need to create an [E]ER-Modell from an existing databasae, >> I mostly use MS Visio professional. It can reverse engineer via >> ODBC lots of DBS. >> >> Rico >> >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> >> >> > > > > ---------------------------(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 > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
hello tony, Our tool DeZign for Databases can do this for you. With the ImportER Scripts add-on you can import SQL scripts containing create table statements etc into the data modeling tool DeZign for Databases. more info at http://www.datanamic.com regards rick reina_ga@hotmail.com (Tony Reina) wrote in message news:<272e4be7.0401121419.37989e3a@posting.google.com>... > I know that there are standard ways to graph relational databases. > > It occured to me that perhaps programs existed which simply parsed the > table definitions and plotted the graphs for you. > > Anyone know of such a thing? > > Thanks. > -Tony