From: Mary Anderson <maryfran@demog.berkeley.edu>
To: Michael Monnerie <michael.monnerie@it-management.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: Documenting a DB schema
Date: Tue, 04 Mar 2008 14:13:02 -0800
Message-ID: <47CDC96E.7090209@demog.berkeley.edu> (raw)
In-Reply-To: <200803042156.51832@zmi.at>
References: <082D8A131DF72A4D88C908A1AD3DEB22023B34F2@mail-1.rf.lan>
<200803042156.51832@zmi.at>
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
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: pgsql-sql@postgresql.org
Cc: maryfran@demog.berkeley.edu, michael.monnerie@it-management.at, pgsql-admin@postgresql.org
Subject: Re: Documenting a DB schema
In-Reply-To: <47CDC96E.7090209@demog.berkeley.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox