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

Lists: pgsql-hackerspgsql-performance
From: Ron Peacetree <rjpeace(at)earthlink(dot)net>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Looking for a tool to "*" pg tables as ERDs
Date: 2006-02-23 16:38:48
Message-ID: 17961438.1140712728036.JavaMail.root@elwamui-rustique.atl.sa.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance

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

Anyone know of one?

TiA
Ron

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Ron Peacetree <rjpeace(at)earthlink(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
Date: 2006-02-23 16:48:01
Message-ID: 43FDE741.7070403@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance

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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: Ron Peacetree <rjpeace(at)earthlink(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
Date: 2006-02-23 16:59:31
Message-ID: 43FDE9F3.9000109@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance

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

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Looking for a tool to "*" pg tables as ERDs
Date: 2006-02-23 17:06:51
Message-ID: 0FFE36E7-A61D-4DC3-A74D-D9549A44A1F6@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance


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

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Ron Peacetree <rjpeace(at)earthlink(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
Date: 2006-02-23 17:20:18
Message-ID: 43FDEED2.6010901@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance

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

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Ron Peacetree <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Looking for a tool to "*" pg tables as ERDs
Date: 2006-03-01 18:31:44
Message-ID: 1141237914.4234.340.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-performance

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