Re: [PERFORM] Looking for a tool to * pg tables as ERDs

[Robert Treat]

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


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Looking for a tool to * pg tables as ERDs

[Vivek Khera]

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




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match