Re: 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 <pj(at)illuminatedcomputing(dot)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(at)gmail(dot)com>
> wrote:
> > Hi,
> >
> > try DBVisualizer
> >
> >
> >
> > --
> >
> > Regards,
> >
> > Bartek
>
>
>
> --
> _________________________________
> Pulchritudo splendor veritatis.
>