Idea: Comments on system catalogs?

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Idea: Comments on system catalogs?
Date: 2007-07-04 11:03:20
Message-ID: 758d5e7f0707040403o16b24eevd42530c948ed454c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello.

I think it could be a nice idea to put descriptions from
http://www.postgresql.org/docs/8.2/static/catalogs.html
into system catalogs itself. I.e., make a bunch of

COMMENT ON COLUMN pg_class.relname
IS 'Name of the table, index, view, etc.';
...
COMMENT ON COLUMN pg_class.relkind
IS 'r = ordinary table, i = index, S = sequence, v = view, c =
composite type, t = TOAST table';

and so on.

I think it could be helpful, when you're writing your own selects
on system catalogs.

Perhaps it could be optional (as a contrib .sql file).

If you like the idea, I could prepare a script which will
convert documentation into .sql file with series of
COMMENT ON .. IS ...;

Regards,
Dawid

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-07-04 11:04:40 Re: ACM Paper relevant to our buffer algorithm
Previous Message Heikki Linnakangas 2007-07-04 10:39:11 Re: ACM Paper relevant to our buffer algorithm