On Mon, 2003-11-10 at 13:58, Gautam Saha wrote:
Is there a ER diagram tool someone can recommend for PostgreSQL?
I should be able to create ER diagram from existing database also
(reverse engineering).
Any open source product would be ideal.
I'd like an open source product too, but haven't seen any. I have used Data Architect (
http://www.thekompany.com/products/dataarchitect/) and Case Studio 2 (
http://www.casestudio.com/enu/products.aspx).
DA is a very reasonably priced, closed-source, Qt/KDE app. I found it a little daunting to configure and get working with unixODBC on linux many months ago, but eventually I did and it's probably better these days. There were a few annoyance bugs related to printing crashes and spacing, as I recall, but eventually I found work arounds for those too.
CS2 worked fairly well, but I remember having some problem with it not being able to reverse engineer a few tables because of column type problems. I don't remember the details, but I did report it. I ran it under VMWare (linux host, win2k guest), so I can tell you that works too.
-Reece
--
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 0xD178AAF9
|