Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands

From: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
Date: 2026-02-27 05:58:36
Message-ID: 663B3251-32EA-4A59-ACCF-8A3B6E140FB8@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Feb 27, 2026, at 07:09, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
> On Thu, Feb 26, 2026 at 10:53 PM Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
>>
>> On 2026-Feb-26, Fujii Masao wrote:
>>
>>> Or both? IOW, display comments if either that psql variable is enabled
>>> or "*" is specified in the \d command; otherwise, omit them.
>>>
>>> With this approach, users who prefer the current behavior (showing comments
>>> with the "+" option) can simply enable that psql variable and see comments
>>> without adding "*". Conversely, users who prefer not to include comments
>>> can disable that variable and use "*" only when they want to display them.
>>
>> I like this, thanks. I wonder though if the variable ought to be more
>> generic.
>
> I'm fine with this direction, but I think it should be handled as a separate
> improvement to the \d meta-commands, rather than as part of the current patch
> extending \dRp+, \dRs+, and \dX+.
>
> I'm thinking to first commit the v3 patch so that comments on publications,
> subscriptions, and extended statistics can be viewed via \d. After that,
> we can consider a broader overhaul of the \d commands and how comments are
> displayed, as discussed.
>

To me, that sounds reasonable.

Best regards,

Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Florents Tselai 2026-02-27 05:59:38 Re: Patch: Add tsmatch JSONPath operator for granular Full Text Search
Previous Message Tatsuo Ishii 2026-02-27 05:55:39 Re: Row pattern recognition