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

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.

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

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

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

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

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