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=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 <bdmyt...@gmail.com> > wrote: > > Hi, > > > > try DBVisualizer > > > > > > > > -- > > > > Regards, > > > > Bartek > > > > -- > _________________________________ > Pulchritudo splendor veritatis. >
