Message-ID: <47CDC96E.7090209@demog.berkeley.edu>
Date: Tue, 04 Mar 2008 14:13:02 -0800
From: Mary Anderson <maryfran@demog.berkeley.edu>
User-Agent: Thunderbird 2.0.0.4 (X11/20070604)
MIME-Version: 1.0
To: Michael Monnerie <michael.monnerie@it-management.at>
CC: pgsql-admin@postgresql.org
Subject: Re: Documenting a DB schema
References: <082D8A131DF72A4D88C908A1AD3DEB22023B34F2@mail-1.rf.lan>
	<200803042156.51832@zmi.at>
In-Reply-To: <200803042156.51832@zmi.at>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

MicroOlap (or MicrOlap) does a nice job of creating schema diagrams for 
postgres.  I have had a little trouble with re-engineering databases 
that have had a lot of alterations, however.  But their tech support is 
reasonable.

Mary


Michael Monnerie wrote:
> On Dienstag, 4. März 2008 Shahaf Abileah wrote:
>> create table table_with_comments(a int comment 'this is
>> column a...');
>> (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html)
>> However, Postgres doesn't support the "comment" keyword.  Is there an
>> alternative?
> 
> This sounds nice at first thought... but: you need to document tables 
> also, and relations between tables etc. And especially the complex 
> dependencies can't be documented that way ("if you insert this here, 
> look into table x and y and compare this with table z, blabla").
> 
> And I'd like to know how often such funny documentation can be found 
> when it's used, take your example:
>> create table table_with_comments(a int comment 'this is
>> column a...');
> I've seen such documentation a lot - just bought a Nokia E65 mobile 
> phone, it's handbook has this kind of documentation printed in it... 
> worthless.
> 
> But, BTW, does anybody have a good tool to show graphically the 
> relations between tables, and maybe even draw relations between tables 
> and create all necessary commands from this automatically? That would 
> be nice, along with documentation features...
> 
> mfg zmi