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
Markus Schaber wrote:
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.
How on earth can either of these have to do with producing an ERD?
postgresql_autodoc might help: http://pgfoundry.org/projects/autodoc/
cheers
andrew
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. :-)
Hi, Andrew,
Andrew Dunstan wrote:
How on earth can either of these have to do with producing an ERD?
Sorry, the ERD thing got lost in my mind while resolving the "*".
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
I'll second autodoc. Been using it with Docbook and Dia for over a year
with good results.
Show quoted text
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of
Andrew Dunstan
Sent: Thursday, February 23, 2006 12:00 PM
To: Markus Schaber
Cc: Ron Peacetree; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [PERFORM] Looking for a tool to "*" pg
tables as ERDsMarkus Schaber wrote:
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.How on earth can either of these have to do with producing an ERD?
postgresql_autodoc might help: http://pgfoundry.org/projects/autodoc/
cheers
andrew
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org
so that your
message can get through to the mailing list cleanly
Import Notes
Resolved by subject fallback
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