JD, * Joshua D. Drake (j...@commandprompt.com) wrote: > Does not use existing comment functionality. Alternate solution > which would decrease functionality is: > > COMMENT ON SETTING setting IS 'comment';
That seems like a pretty reasonable idea, at least from where I sit.
> Looking forward, we may want to do the following:
>
> 1. Make it so any object can have a comment with creation, e.g;
>
> CREATE TABLE table () COMMENT IS '';
I'm pretty sure this has been discussed previously.
> 2. Make it so comments are appended not replaced.
Having COMMENT ON accept a general query whose result is then cast to
text and stored as the comment would allow this to be done, eg:
COMMENT ON table IS (pg_get_comment('table') || ' new text');
We could also have new syntax along these lines, for this specific case:
COMMENT ON table ADD ' new text';
Though we have this pretty powerful language, seems a bit of a shame to
invent something new for working with comments.
Thanks!
Stephen
signature.asc
Description: Digital signature
