Re: Any freeware graphic display of DDL software available?

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.

In response to

Responses

Browse pgsql-general by date

  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