Re: Looking for a tool to "*" pg tables as ERDs

On Feb 23, 2006, at 11:38 AM, Ron Peacetree wrote:

> Where "*" ==
> {print | save to PDF | save to <mumble> format | display on screen}
>
> Anyone know of one?

There's a perl module, GraphViz::DBI::General, which does a rather
nifty job of taking a schema and making a graphviz "dot" file from
it, which can then be processed into any of a bazillion formats.

It basically makes a box for each table, with fields, and an arrow to
each FK referenced table. All layed out nicely.

You may also want to investigate the SQLFairy < http://
sqlfairy.sourceforge.net/ > if not for anything besides their awesome
logo. :-)