Thread

Re: psql: display of object comments

Robert Haas <robertmhaas@gmail.com> — 2011-08-08T20:34:57Z

On Fri, Aug 5, 2011 at 7:25 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> On Fri, Aug 5, 2011 at 8:32 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> I guess my vote is to make the SQL/MED stuff show the description only
>> in verbose mode, and always at the end; and revise what we did with
>> \dL to put the description at the end even in verbose mode.
>
> Yeah, that sounds fine to me. I've revised the residual patch to do
> so, as well as incorporated your earlier suggestion about having \dD
> and \dc only display descriptions in verbose-mode.
>
> I did more testing, and found and fixed some brokenness related to
> d.objsubid I had introduced into the listConversions() query, as well
> as improved the version checking in objectDescription(). Updated patch
> attached.

OK, I've now committed most of this, with some additions to the
documentation.  Remaining bits attached.

I am a bit confused as to why we have both \det and \dE.  They seem
redundant.  Shouldn't we rip one of those out?  IMHO, \det should be
the one to go, as it could be useful to do, e.g. \dtvE, which isn't
going to work with the \det syntax.

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