From: | "Tom Pfau" <T(dot)Pfau(at)emCrit(dot)com> |
---|---|
To: | "Peter Darley" <pdarley(at)kinesis-cem(dot)com>, "Oberpriller, Wade D(dot)" <oberpwd(at)nsc-msg01(dot)network(dot)com>, "PostgreSQL General Help (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Visual display tool? |
Date: | 2002-03-20 14:43:54 |
Message-ID: | 5C47691674725C47B02996F02C0D362107B63D@exchange.rane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yeah, Visio can reverse engineer your database and make a pretty picture
but it doesn't support PostgreSQL very well for generating a database.
It loses any foreign key constraint options (ON DELETE, ON UPDATE) that
you might set. It's also a pig (takes several minutes to load our
database diagram of about 50 tables). We're evaluating Data Architect
(http://www.theKompany.com/)
-----Original Message-----
From: Peter Darley [mailto:pdarley(at)kinesis-cem(dot)com]
Sent: Tuesday, March 19, 2002 4:42 PM
To: Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: Re: [GENERAL] Visual display tool?
Wade,
Probably won't be a hit here, since it's not open source, and is
indeed
owned by Microsoft, but Visio does an excellent job of this. Using an
ODBC
connection it can decompile a database, draw out foreign key relations,
etc.
Very slick.
Thanks,
Peter D.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Oberpriller,
Wade D.
Sent: Tuesday, March 19, 2002 7:43 AM
To: PostgreSQL General Help (E-mail)
Subject: [GENERAL] Visual display tool?
Can anyone recommend a visual display tool to create a picture (i.e.
table
layouts and relationships) of my database? Pictures are worth a thousand
words.
Wade Oberpriller http://www.storagetek.com
Software Development Phone: (763) 424-1538
StorageTek: MRDC (800) 328-9108 ext. 1538
wade_oberpriller(at)storagetek(dot)com Fax: (763) 391-1095
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Darley | 2002-03-20 14:44:24 | Re: Visual display tool? |
Previous Message | wsheldah | 2002-03-20 14:26:42 | Re: Access to Postgres query problem |