pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Are there programs to graph database schema?
9+ messages / 8 participants
[nested] [flat]

* Are there programs to graph database schema?
@ 2004-01-12 22:19  Tony Reina <reina_ga@hotmail.com>
  0 siblings, 2 replies; 9+ messages in thread

From: reina_ga@hotmail.com @ 2004-01-12 22:19 UTC (permalink / raw)
  To: pgsql-admin

I know that there are standard ways to graph relational databases. 

It occured to me that perhaps programs existed which simply parsed the
table definitions and plotted the graphs for you.

Anyone know of such a thing?

Thanks.
-Tony



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-14 08:02  Enrico Ortmann <pg.admin@radax.net>
  parent: Tony Reina <reina_ga@hotmail.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Enrico Ortmann @ 2004-01-14 08:02 UTC (permalink / raw)
  To: pgsql-admin

Hi Tony,

TR> It occured to me that perhaps programs existed which simply parsed the
TR> table definitions and plotted the graphs for you.

If I need to create an [E]ER-Modell from an existing databasae,
I mostly use MS Visio professional. It can reverse engineer via
ODBC lots of DBS.

Rico






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-14 14:15  Juan Miguel <juanmime@ono.com>
  parent: Enrico Ortmann <pg.admin@radax.net>
  0 siblings, 3 replies; 9+ messages in thread

From: Juan Miguel @ 2004-01-14 14:15 UTC (permalink / raw)
  To: pgsql-admin

Hi, I use MS Visio Professional, and it works (not very good), but it works.
I ever wondered if there is a opensource tool, that let me create an 
automatic ER-Model diagram from an existing DB, like MS Visio.
Do you know if this tool exists ?

Thanks

>Hi Tony,
>
>TR> It occured to me that perhaps programs existed which simply parsed the
>TR> table definitions and plotted the graphs for you.
>
>If I need to create an [E]ER-Modell from an existing databasae,
>I mostly use MS Visio professional. It can reverse engineer via
>ODBC lots of DBS.
>
>Rico
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>  
>





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-14 15:54  Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
  parent: Juan Miguel <juanmime@ono.com>
  2 siblings, 0 replies; 9+ messages in thread

From: Thierry Missimilly @ 2004-01-14 15:54 UTC (permalink / raw)
  To: Juan Miguel <juanmime@ono.com>; +Cc: pgsql-admin

Hi,

For a small schema, i've used PGACESS. There is a graphical editor which help
you to draw boxes with the foreign keys.

Thierry

Juan Miguel wrote:

> Hi, I use MS Visio Professional, and it works (not very good), but it works.
> I ever wondered if there is a opensource tool, that let me create an
> automatic ER-Model diagram from an existing DB, like MS Visio.
> Do you know if this tool exists ?
>
> Thanks
>
> >Hi Tony,
> >
> >TR> It occured to me that perhaps programs existed which simply parsed the
> >TR> table definitions and plotted the graphs for you.
> >
> >If I need to create an [E]ER-Modell from an existing databasae,
> >I mostly use MS Visio professional. It can reverse engineer via
> >ODBC lots of DBS.
> >
> >Rico
> >
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
> >
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

Attachments:

THIERRY.MISSIMILLY.vcf (text/x-vcard, 326B) download begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/R&D adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:Thierry.Missimilly@bull.net x-mozilla-cpt:;-18184 fn:Thierry Missimilly end:vcard
^ permalink raw reply [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-14 16:15  Enrico Ortmann <pg.admin@radax.net>
  parent: Juan Miguel <juanmime@ono.com>
  2 siblings, 1 reply; 9+ messages in thread

From: Enrico Ortmann @ 2004-01-14 16:15 UTC (permalink / raw)
  To: pgsql-admin

Guten Tag Juan Miguel,

Hi Juan,

JM> Hi, I use MS Visio Professional, and it works (not very good), but it works.
JM> I ever wondered if there is a opensource tool, that let me create an
JM> automatic ER-Model diagram from an existing DB, like MS Visio.
JM> Do you know if this tool exists ?

Unfortunately I don't. I am unsatisfied with Visio too, but the point
of reason for using it is exactly that I don't know a better tool.
If anybody does - please let me know!

Rico




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-14 18:26  Rajesh Kumar Mallah <mallah@trade-india.com>
  parent: Juan Miguel <juanmime@ono.com>
  2 siblings, 0 replies; 9+ messages in thread

From: Rajesh Kumar Mallah @ 2004-01-14 18:26 UTC (permalink / raw)
  To: Juan Miguel <juanmime@ono.com>; +Cc: pgsql-admin

Juan Miguel wrote:

Greetings!

pg_autodoc

http://www.rbt.ca/autodoc/index.html

can produce .dot files that can be charted using
graphviz.

http://www.graphviz.org/

It works pretty well for medium sized databases
but for large it tends to produce a spaghetti.

Check the "Related Sites" in graphviz.org homepage.



Regds
mallah.



> Hi, I use MS Visio Professional, and it works (not very good), but it 
> works.
> I ever wondered if there is a opensource tool, that let me create an 
> automatic ER-Model diagram from an existing DB, like MS Visio.
> Do you know if this tool exists ?
>
> Thanks
>
>> Hi Tony,
>>
>> TR> It occured to me that perhaps programs existed which simply 
>> parsed the
>> TR> table definitions and plotted the graphs for you.
>>
>> If I need to create an [E]ER-Modell from an existing databasae,
>> I mostly use MS Visio professional. It can reverse engineer via
>> ODBC lots of DBS.
>>
>> Rico
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>>
>>  
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if 
> your
>      joining column's datatypes do not match
>





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-15 09:58  Leslie <lid@ucs.co.za>
  parent: Enrico Ortmann <pg.admin@radax.net>
  0 siblings, 0 replies; 9+ messages in thread

From: Leslie @ 2004-01-15 09:58 UTC (permalink / raw)
  To: Enrico Ortmann <pg.admin@radax.net>; +Cc: pgsql-admin

Hi All , 

Have a look at DbVisualizer-4.0.2
Java based ER tool that works very well.

Regards.
Leslie.



On Wed, 2004-01-14 at 18:15, Enrico Ortmann wrote:
> Guten Tag Juan Miguel,
> 
> Hi Juan,
> 
> JM> Hi, I use MS Visio Professional, and it works (not very good), but it works.
> JM> I ever wondered if there is a opensource tool, that let me create an
> JM> automatic ER-Model diagram from an existing DB, like MS Visio.
> JM> Do you know if this tool exists ?
> 
> Unfortunately I don't. I am unsatisfied with Visio too, but the point
> of reason for using it is exactly that I don't know a better tool.
> If anybody does - please let me know!
> 
> Rico
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-15 10:19  Hal Angseesing <hal.angseesing@warhammeronline.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Hal Angseesing @ 2004-01-15 10:19 UTC (permalink / raw)
  To: pgsql-admin

We recently purchased DBVisualizer. It's really quite good for this kind of diagram (some quirks).
http://www.dbvis.com

It's not open source though and you do have a small charge to pay.
Cheers,
Hal.

-----Original Message-----
From: Rajesh Kumar Mallah [mailto:mallah@trade-india.com]
Sent: 14 January 2004 18:26
To: Juan Miguel
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Are there programs to graph database schema?


Juan Miguel wrote:

Greetings!

pg_autodoc

http://www.rbt.ca/autodoc/index.html

can produce .dot files that can be charted using
graphviz.

http://www.graphviz.org/

It works pretty well for medium sized databases
but for large it tends to produce a spaghetti.

Check the "Related Sites" in graphviz.org homepage.



Regds
mallah.



> Hi, I use MS Visio Professional, and it works (not very good), but it 
> works.
> I ever wondered if there is a opensource tool, that let me create an 
> automatic ER-Model diagram from an existing DB, like MS Visio.
> Do you know if this tool exists ?
>
> Thanks
>
>> Hi Tony,
>>
>> TR> It occured to me that perhaps programs existed which simply 
>> parsed the
>> TR> table definitions and plotted the graphs for you.
>>
>> If I need to create an [E]ER-Modell from an existing databasae,
>> I mostly use MS Visio professional. It can reverse engineer via
>> ODBC lots of DBS.
>>
>> Rico
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>>
>>  
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if 
> your
>      joining column's datatypes do not match
>



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

               http://www.postgresql.org/docs/faqs/FAQ.html



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Are there programs to graph database schema?
@ 2004-01-29 14:35  Rick van Dijk <info@datanamic.com>
  parent: Tony Reina <reina_ga@hotmail.com>
  1 sibling, 0 replies; 9+ messages in thread

From: info@datanamic.com @ 2004-01-29 14:35 UTC (permalink / raw)
  To: pgsql-admin

hello tony,

Our tool DeZign for Databases can do this for you. With the ImportER
Scripts add-on you can import SQL scripts containing create table
statements etc into the data modeling tool DeZign for Databases.

more info at
http://www.datanamic.com

regards
rick

reina_ga@hotmail.com (Tony Reina) wrote in message news:<272e4be7.0401121419.37989e3a@posting.google.com>...
> I know that there are standard ways to graph relational databases. 
> 
> It occured to me that perhaps programs existed which simply parsed the
> table definitions and plotted the graphs for you.
> 
> Anyone know of such a thing?
> 
> Thanks.
> -Tony



^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2004-01-29 14:35 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-12 22:19 Are there programs to graph database schema? Tony Reina <reina_ga@hotmail.com>
2004-01-14 08:02 ` Enrico Ortmann <pg.admin@radax.net>
2004-01-14 14:15   ` Juan Miguel <juanmime@ono.com>
2004-01-14 15:54     ` Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
2004-01-14 16:15     ` Enrico Ortmann <pg.admin@radax.net>
2004-01-15 09:58       ` Leslie <lid@ucs.co.za>
2004-01-14 18:26     ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-01-29 14:35 ` Rick van Dijk <info@datanamic.com>
2004-01-15 10:19 Re: Are there programs to graph database schema? Hal Angseesing <hal.angseesing@warhammeronline.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox