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
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 |