Re: pg_comments (was: Allow \dd to show constraint comments) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_comments (was: Allow \dd to show constraint comments)
Date
Msg-id CA+Tgmoai4WchHx4c_nrzyabZ=70kSac6WjBqK8T3vuGavEtb5A@mail.gmail.com
Whole thread Raw
In response to Re: pg_comments (was: Allow \dd to show constraint comments)  (Thom Brown <thom@linux.com>)
Responses Re: pg_comments (was: Allow \dd to show constraint comments)
List pgsql-hackers
On Tue, Nov 8, 2011 at 8:12 PM, Thom Brown <thom@linux.com> wrote:
> Why is this marked as done on with Wiki's todo list?

I assume you're referring to this item:

--
\dd is missing comments for several types of objects.  Comments are
not handled at all for some object types, and are handled by both \dd
and the individual backslash command for others. Consider a system
view like pg_comments to manage this mess.
--

What we did is modify psql so that all the backslash commands display
comments for their corresponding object types, at least when the +
modifier is used.  We then made \dd display comments for all object
types that lack their own backslash commands.  That seems like it
pretty much covers the todo item.

I initially thought that pg_comments could be used *by psql*, which
seemed to me a good argument in favor of its general utility.  When we
didn't end up doing it that way, the view got less appealing to me.
I'm still willing to add it if enough people say they want it, but so
far I think we've gotten about three votes between +0.25 and +0.50 and
a -1 from Tom.  Which is not really enough for me to feel like pulling
the trigger.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: proposal: psql concise mode
Next
From: Tom Lane
Date:
Subject: Re: proposal: psql concise mode