Feedback-ID: ie3de48e3:Fastmail
Date: Fri, 20 Feb 2026 16:48:40 +0100
From: =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
Message-ID: <202602201522.fbznppk5cxmz@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAHGQGwGL4JqiKA26fnGx-cTM=VzoTs_uzqejvj4Fawyr4uLUUw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/202602201522.fbznppk5cxmz%40alvherre.pgsql>
Precedence: bulk

On 2026-Feb-16, Fujii Masao wrote:

> The psql meta-commands that list publications, subscriptions, and extended
> statistics (\dRp+, \dRs+, and \dX+) do not display their associated comments,
> whereas other \d meta-commands do. This makes it inconvenient to view
> these objects together with their descriptions.

I'm not in love with the fact that some "plus" commands display the
description and I wish I had a way to turn that off.  On the other hand,
sometimes I want to see the comments for objects and little else.
But I think it's infrequent that I want to see both the comments and
simultaneously the details that only appear in verbose mode.

This is to say that I'm also not in love with expanding the "plus"
commands to print comments in more cases as you propose, and I wonder if
we can find something more ergonomical.  For instance, what if we added
a second flag to the commands (eg. an asterisk/star, but could be
anything that's easily typed), so that you can invoke the normal
"verbose" bit separately from the comments?  So if you want details but
no comments, you use "\d+", and if you want comments but no details you
use "\d*", and if you want everything, then you use \d+* or \d*+?

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)