Re: How to make a good documentation of a database ?

From: Timothy Perrigo <tperrigo(at)wernervas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to make a good documentation of a database ?
Date: 2004-11-18 15:10:19
Message-ID: F5F27A3C-3973-11D9-A237-000A95C4F0A2@wernervas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Autodoc might be useful: http://www.rbt.ca/autodoc/

On Nov 18, 2004, at 8:31 AM, David Pradier wrote:

> Hi !
>
> I've just inherited the responsibility of a postgresql database
> of roughly 480 tables and 6460 columns, mainly without constraints,
> not even foreign keys.
>
> I'd like to make it a little more orthodox (lots and lots of
> constraints, yeah !!), but I need a tool to make a documentation about
> every column, at least, as some column are really vicious (like, they
> are a foreign key to a table which depends on the type of another
> column...).
>
> The best idea I could come with to do that was to maintain an output of
> pgdump --shema-only, versioned with cvs, annotated with a patch, itself
> versioned with cvs.
> Not that bright, isn't it ?
>
> The problem is, I don't want to use a lot of time to maintain this
> documentation, and above all, I'd prefer not to insert the information
> twice (read: a new constraint in the database should automagically
> update the documentation).
>
> Does somebody know the right way to do this ?
>
> Best regards,
> David Pradier
>
> --
> dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.45.20.17.98
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2004-11-18 15:11:26 Re: Certifications in military environment
Previous Message Tom Lane 2004-11-18 15:08:29 Re: How to know a record has been updated, then reset the flag?