Message-ID: <ed8e31bd-a33e-4259-a91b-fe9cb048b49d@postgrespro.ru>
Date: Thu, 26 Feb 2026 07:57:10 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>,
 Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <202602201522.fbznppk5cxmz@alvherre.pgsql>
Content-Language: en-US, ru
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: <202602201522.fbznppk5cxmz@alvherre.pgsql>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/ed8e31bd-a33e-4259-a91b-fe9cb048b49d%40postgrespro.ru>
Precedence: bulk

On 20.02.2026 18:48, Álvaro Herrera wrote:
>   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*+?

We need to keep in mind two more modifiers: S for system objects and x 
for eXtended mode.
So it may be looks like slightly awkward: \dSx+*

Another option is to use psql variable (for example ECHO_COMMENTS 
on/off) to force comments in \d* commands.

I'm not sure what option is better. But I like the idea of printing 
comments.

-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com