public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mary Anderson <[email protected]>
To: Michael Monnerie <[email protected]>
Cc: [email protected]
Subject: Re: Documenting a DB schema
Date: Tue, 04 Mar 2008 14:13:02 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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

view thread (11+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Documenting a DB schema
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox