Re: Visual display tool?

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@kinesis-cem.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@postgresql.org
[mailto:pgsql-general-owner@postgresql.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@storagetek.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@postgresql.org)


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

http://www.postgresql.org/users-lounge/docs/faq.html