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

Sparx architect

Regards

On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert <Karsten.Hilbert@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

Hi,
try DBVisualizer

--
Regards,
Bartek

I use this script on an Ubuntu system:

#!/bin/bash

set -eu

postgresql_autodoc -d example_dev -u example_dev -h localhost
--password=xxxxxxxx
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 <bdmytrak@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

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 <bdmytrak@gmail.com> wrote:

On Thu, Jan 16, 2014 at 2:57 PM, Susan Cassidy <
susan.cassidy@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.

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 <pj@illuminatedcomputing.com

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.klaver@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

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

On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy
<susan.cassidy@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

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-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Susan Cassidy
Sent: Thursday, January 16, 2014 2:57 PM
To: Bartosz Dmytrak
Cc: pgsql-general@postgresql.org; Karsten.Hilbert@gmx.net; s_jubeh@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 <bdmytrak@gmail.com<mailto:bdmytrak@gmail.com>> wrote:

Hi,

try DBVisualizer

--

Regards,

Bartek

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

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 <mmoncure@gmail.com>
wrote:

On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy
<susan.cassidy@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