Re: ER diagrams - Mailing list pgsql-general

From Karl DeBisschop
Subject Re: ER diagrams
Date
Msg-id 3AFAB990.3736C1FC@alert.infoplease.com
Whole thread Raw
In response to Re: ER diagrams  (martin.chantler@convergys.com)
List pgsql-general
martin.chantler@convergys.com wrote:
>
> Visio 2000 comes with a set of drivers which includes an ODBC driver
> I haven't tried Visio with Postgres but hopefully it would work, it did
> manage to import a DB2 database using the ODBC driver.
>
> It does work but it is a bit annoying to use!
> I heard a rumour that the database documenter is only included with the
> enterprise version but I'm not sure about this. I mention it in case anyone
> buys Visio and finds the feature is not there.

We bought Visio Enterprise specifically for ER diagrams of our postgreSQL databases. It imports them fine, but we had a
bearof a time trying to cleary indicate primary key relationships. We could show which tables were keyed to each other,
buttrying to show which attributes were the keys, and having that persist as we moved things around was never done
successfully.

It could well have been operator problems. But time matters, in the end it was much quicker to install and learn Dia.
Andit did everything we needed, on our Linux boxes to boot. 

End result? I hate to disparage anyones work so I will simply note that the large box/manual set makes an excellent
bookend.

--
Karl

pgsql-general by date:

Previous
From: "Mark R"
Date:
Subject: Newbie HOWTO
Next
From: Roger Wernersson
Date:
Subject: Re: SQL Server -> Postgres migration: Stored Procedure replacement?