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

Where "*" ==
{print | save to PDF | save to <mumble> format | display on screen}

Anyone know of one?

TiA
Ron

Hi, Ron,

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

psql with fancy output formatting comes to my mind, or "COPY table TO
file" SQL command.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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. :-)

On Thu, 2006-02-23 at 11:38, Ron Peacetree wrote:
> Where "*" ==
> {print | save to PDF | save to <mumble> format | display on screen}
>
> Anyone know of one?
>

case studio can reverse engineer erd's from existing schema, and you can
print out the schema, create html or rdf reports, or export the erd as a
graphic. Downside is it can't do direct port to pdf (though you could
get around that with OO i imagine), plus its windows only and
commercial.


Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL