Postgres Pro
Downloads
Home   >   mailing lists

Re: Any freeware graphic display of DDL software available? - Mailing list pgsql-general

From Susan Cassidy
Subject Re: Any freeware graphic display of DDL software available?
Date
Msg-id CAE3Q8omuRQUBYiyYFtyoaJ2drreRtdaVZx-xBR-MXeQ7k3NszA@mail.gmail.com
Whole thread Raw
In response to Re: Any freeware graphic display of DDL software available?  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: Any freeware graphic display of DDL software available?
Re: Any freeware graphic display of DDL software available?
List pgsql-general
Tree view
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> wrote:
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.

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: Any freeware graphic display of DDL software available?
Next
From: Adrian Klaver
Date:
Subject: Re: Any freeware graphic display of DDL software available?