"Rod Taylor" <rbt@zort.ca> writes:
> COMMENT ON DATABASE db IS 'Comment';
> Now switch databases. Comment is gone.
Yeah, it's not very helpful. I'm not sure why we bothered to implement
that in the first place.
> I suppose in order to add a comment field to pg_database it would need
> to be toasted or something (ton of work). Any other way to fix this?
I'm more inclined to rip it out ;-). I don't think it's worth the
trouble. Keeping database comments someplace else than pg_description
is certainly *not* the way to go --- everything that reads them would
have to be tweaked too.
What does need to be added at the moment is COMMENT ON SCHEMA (a/k/a
namespace).
regards, tom lane