Re: [GENERAL] Any freeware graphic display of DDL software available?
If you use Amazon Linux on EC2, we have packaged SchemaSpy support for it. More details are here, https://lambda-linux.io/blog/2015/05/07/announcing-schemaspy-support-for-amazon-linux/ Best, Rajiv On Thu, Jan 16, 2014 at 7:46 PM, Merlin Moncure mmonc...@gmail.com wrote: On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. I know about Erwin, but it is too expensive. I want to give a shout out for schemaspy . I think it's about the best ERD tool out there; the graphviz relationship mapping 'just works' and you have to spend zero time mucking around with the tool post extraction which is a critical flaw with many ERD tools. It's aware but there are undocumented switches to remove the ads. My experience is that ERD tools that require manual steps of any kind tend to become quickly out of date and useless. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
O n Thu, 2014-01-16 at 08:45 -0800, Susan Cassidy wrote: I know about Erwin, but it is too expensive.T hanks, Susan You can try ExecuteQuery from www.executequery.org. It is written in Java so needs the JDBC driver to access the database. It cannot read a DDL script but obtains meta data from the catalogue tables and can produce an ER diagram. It can do lots of other things too. It has to connect to the database, so PostgreeSql has to be running. There is a .deb package available for download. You'll need a JDK 1.6 or greater. I use it all the time. Cheers, Robert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. pg_autodoc Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
Sparx architect Regards On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert karsten.hilb...@gmx.net wrote: On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. pg_autodoc Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
Hi, try DBVisualizer -- Regards, Bartek
Re: [GENERAL] Any freeware graphic display of DDL software available?
I use this script on an Ubuntu system: #!/bin/bash set -eu postgresql_autodoc -d example_dev -u example_dev -h localhost --password= dot -Tpng -o example-schema.png example_dev.dot dot -Tpdf -o example-schema.pdf example_dev.dot That gives you a schema diagram in pdf, png, dia, and dot format, including foreign keys. It also exports the table and column info as html and xml. I'm pretty sure you can install postgresql_autodoc with apt-get, but I don't recall for sure now. Good luck! Paul On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek -- _ Pulchritudo splendor veritatis. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. Thanks, Susan On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek
Re: [GENERAL] Any freeware graphic display of DDL software available?
On Thu, Jan 16, 2014 at 2:57 PM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. DBSchema outputs ER diagrams: http://www.dbschema.com/database-er-diagrams.html I think the paid version is about $300 IIRC.
Re: [GENERAL] Any freeware graphic display of DDL software available?
What are the dot lines for? They don't seem to work on my Linux installation. I tried adding them to the initial line, and I see no .pdf output. I just see: Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl Producing testdb.dot from /usr/share/postgresql_autodoc/dot.tmpl Producing testdb.html from /usr/share/postgresql_autodoc/html.tmpl Producing testdb.neato from /usr/share/postgresql_autodoc/neato.tmpl Producing testdb.xml from /usr/share/postgresql_autodoc/xml.tmpl Producing testdb.zigzag.dia from /usr/share/postgresql_autodoc/zigzag.dia.tmpl The .html file just shows a table-like representation of each individual table, which is no real use to me, as I need the relationships between tables to show graphically. What do I do with a .dot or .dia formatted file? Thanks, Susan On Thu, Jan 16, 2014 at 2:06 PM, Paul Jungwirth p...@illuminatedcomputing.com wrote: I use this script on an Ubuntu system: #!/bin/bash set -eu postgresql_autodoc -d example_dev -u example_dev -h localhost --password= dot -Tpng -o example-schema.png example_dev.dot dot -Tpdf -o example-schema.pdf example_dev.dot That gives you a schema diagram in pdf, png, dia, and dot format, including foreign keys. It also exports the table and column info as html and xml. I'm pretty sure you can install postgresql_autodoc with apt-get, but I don't recall for sure now. Good luck! Paul On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek -- _ Pulchritudo splendor veritatis.
Re: [GENERAL] Any freeware graphic display of DDL software available?
On 01/16/2014 03:12 PM, Susan Cassidy wrote: What are the dot lines for? They don't seem to work on my Linux installation. I tried adding them to the initial line, and I see no .pdf output. I just see: Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl Producing testdb.dot from /usr/share/postgresql_autodoc/dot.tmpl Producing testdb.html from /usr/share/postgresql_autodoc/html.tmpl Producing testdb.neato from /usr/share/postgresql_autodoc/neato.tmpl Producing testdb.xml from /usr/share/postgresql_autodoc/xml.tmpl Producing testdb.zigzag.dia from /usr/share/postgresql_autodoc/zigzag.dia.tmpl The .html file just shows a table-like representation of each individual table, which is no real use to me, as I need the relationships between tables to show graphically. What do I do with a .dot or .dia formatted file? http://www.rbt.ca/autodoc/output.html Where GraphViz = dot. Thanks, Susan -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
On 1/16/2014 3:12 PM, Susan Cassidy wrote: What do I do with a .dot or .dia formatted file? not sure about .DOT, but .DIA is probably for the Dia drawing program, which is a simple Vizio like program, free open source. -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. I know about Erwin, but it is too expensive. I want to give a shout out for schemaspy . I think it's about the best ERD tool out there; the graphviz relationship mapping 'just works' and you have to spend zero time mucking around with the tool post extraction which is a critical flaw with many ERD tools. It's aware but there are undocumented switches to remove the ads. My experience is that ERD tools that require manual steps of any kind tend to become quickly out of date and useless. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Any freeware graphic display of DDL software available?
Mogwai: http://sourceforge.net/projects/mogwai/?source=directory Needs JDBC drivers, but most database systems, including Postgres have one. It is a little fiddly setting it up, but it seems to work with lots of data sources. Make sure the PosgreSQL jdbc driver is in the class path before you use it. From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Susan Cassidy Sent: Thursday, January 16, 2014 2:57 PM To: Bartosz Dmytrak Cc: pgsql-general@postgresql.org; karsten.hilb...@gmx.net; s_ju...@yahoo.com Subject: Re: [GENERAL] Any freeware graphic display of DDL software available? It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. Thanks, Susan On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.commailto:bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek