Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-14 Thread Vivek Khera


On Sep 12, 2007, at 7:32 PM, Andrew Hammond wrote:

Does anyone know where I could find a tool which allows importing  
schema information from a postgres database into visio? The boss  
guys want some pretty pictures...


See SQLFairy.  it can generate pretty pictures directly from the  
schemas.  I also have some script somewhere that generates graphviz  
output which makes optimal graphs.




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


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-13 Thread Dimitri Fontaine
Hi list,

Le jeudi 13 septembre 2007, Andrew Hammond a écrit :
> Does anyone know where I could find a tool which allows importing schema
> information from a postgres database into visio? The boss guys want some
> pretty pictures...

Druid[1] is somewhat capable of delivering nice pictures out of an existing 
database, though not on an automated way --- you have to import each table 
one by one then sketch the schema out of this yourself, only linking of 
tables is automatic. But the advantage not found on other tools is its 
ability to create as much E/R views as needed, with whatever tables set on 
them (same table on several E/R views is possible).

This allows for hand-crafting nice part picture to print, each one 
corresponding to a logical part of the database instead of what was easy to 
print out on some A4/letter pages.

For fully automatic processing, you can also try SchemaSpy[2] which is ok for 
online browsing the schema, but not so much for dead-tree form.

 [1] http://druid.sourceforge.net/
 [2] http://schemaspy.sourceforge.net/

Hope this helps, regards,
-- 
dim


signature.asc
Description: This is a digitally signed message part.


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread Norberto Meijome
On Wed, 12 Sep 2007 23:32:24 -0400
Bruno Lavoie <[EMAIL PROTECTED]> wrote:

> you can also look at Case Studio, this software have a nice reverse 
> engineering functionnality!

hear hear - great little tool

_
{Beto|Norberto|Numard} Meijome

"A tyrant...is always stirring up some war or other, in order that the people 
may require a leader."
  Plato

I speak for myself, not my employer. Contents may be hot. Slippery when wet. 
Reading disclaimers makes you go blind. Writing them is worse. You have been 
Warned.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread Josh Trutwin
On Wed, 12 Sep 2007 23:32:24 -0400
Bruno Lavoie <[EMAIL PROTECTED]> wrote:

> Helllo,
> 
> you can also look at Case Studio, this software have a nice reverse 
> engineering functionnality!
> 
> Good luck
> Bruno Lavoie
> 
> Andrew Hammond a écrit :
> > Does anyone know where I could find a tool which allows importing 
> > schema information from a postgres database into visio? The boss
> > guys want some pretty pictures...


dbvisualizer does a nice job reverse engineering schemas (assuming
the fk's are defined, NOT implied)  :)

http://www.dbvis.com/products/dbvis/

Here's a sample:

http://www.smcing.com/images/pb_schema.jpg

Josh

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread Bruno Lavoie

Helllo,

you can also look at Case Studio, this software have a nice reverse 
engineering functionnality!


Good luck
Bruno Lavoie

Andrew Hammond a écrit :
Does anyone know where I could find a tool which allows importing 
schema information from a postgres database into visio? The boss guys 
want some pretty pictures...


Andrew



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


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread Steve Atkins


On Sep 12, 2007, at 4:32 PM, Andrew Hammond wrote:

Does anyone know where I could find a tool which allows importing  
schema information from a postgres database into visio? The boss  
guys want some pretty pictures...


Visio has that built-in for a long time - point it at the database  
via ODBC and let it go.


Cheers,
  Steve




---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread David Fetter
On Wed, Sep 12, 2007 at 04:32:22PM -0700, Andrew Hammond wrote:
> Does anyone know where I could find a tool which allows importing
> schema information from a postgres database into visio? The boss
> guys want some pretty pictures...

I'm pretty sure VisioPro has a way to attach to databases via ODBC
and/or .NET.

Cheers,
David.
-- 
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
  Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

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


[GENERAL] importing pgsql schema into visio (for diagramming)

2007-09-12 Thread Andrew Hammond
Does anyone know where I could find a tool which allows importing schema
information from a postgres database into visio? The boss guys want some
pretty pictures...

Andrew