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

On Thu, Nov 18, 2004 at 04:22:28PM +0000, Richard Huxton wrote:
> David Pradier wrote:
> >In fact, I have already looked a little into the tables of PostgreSQL
> >itself
> >to see if I could hack it by adding a column "Comments" in the "table of
> >columns".
> >But I guess it isn't wise nor feasible, is it ?
>
> You are familiar with:
> COMMENT ON TABLE t IS 'this is my table';
> And \d+
>
> The comments get dumped with their associated object too.

No, I was not :-)
Wow, thanks Richard !
It's exactly what i wanted.

"Prepare to revive foul ghosts of foreign keys,
Prepare to die horrible doubts of the database pit,
Light is to be unleashed on you soon
and great is the relief shining on me."

David Pradier

--
dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.45.20.17.98