From: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
---|---|
To: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org>, susan(dot)cassidy(at)decisionsciencescorp(dot)com, Karsten(dot)Hilbert(at)gmx(dot)net, s_jubeh(at)yahoo(dot)com |
Subject: | Re: Any freeware graphic display of DDL software available? |
Date: | 2014-01-16 22:06:37 |
Message-ID: | CA+6hpanHY77iKn3NYyst8XxxZ7OM_e+0=toP0QpTXDo38XZnSw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2014-01-16 22:55:32 | Re: Looking for settings/configuration for FASTEST reindex on idle system. |
Previous Message | Clemens Eisserer | 2014-01-16 21:42:28 | Re: PostgreSQL with ZFS on Linux |