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

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
Date: 2026-02-28 14:58:06
Message-ID: E1vwLle-001ZJc-0n@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Previously, the psql meta-commands that list publications, subscriptions,
and extended statistics did not display their associated comments,
whereas other \d meta-commands did. This made it inconvenient for users
to view these objects together with their descriptions.

This commit improves \dRp+ and \dRs+ to include comments for publications
and subscriptions. It also extends the \dX meta-command to accept the + option,
allowing comments for extended statistics to be shown when requested.

Author: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Co-authored-by: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Reviewed-by: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAHGQGwGL4JqiKA26fnGx-cTM=VzoTs_uzqejvj4Fawyr4uLUUw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/aecc558666ad62fbecb08ff7af1394656811a581

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 4 +-
src/bin/psql/command.c | 2 +-
src/bin/psql/describe.c | 40 ++-
src/bin/psql/describe.h | 2 +-
src/bin/psql/help.c | 2 +-
src/test/regress/expected/publication.out | 456 ++++++++++++++---------------
src/test/regress/expected/stats_ext.out | 60 ++--
src/test/regress/expected/subscription.out | 176 +++++------
8 files changed, 379 insertions(+), 363 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2026-03-01 17:57:01 pgsql: Correctly calculate "MCV frequency" for a unique column.
Previous Message John Naylor 2026-02-28 09:30:19 pgsql: Refactor detection of x86 ZMM registers