pgsql: psql \dP: list partitioned tables and indexes

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql \dP: list partitioned tables and indexes
Date: 2019-04-07 19:07:39
Message-ID: E1hDD8l-0002Pf-W7@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

psql \dP: list partitioned tables and indexes

The new command lists partitioned relations (tables and/or indexes),
possibly with their sizes, possibly including partitioned partitions;
their parents (if not top-level); if indexes show the tables they belong
to; and their descriptions.

While there are various possible improvements to this, having it in this
form is already a great improvement over not having any way to obtain
this report.

Author: Pavel Stěhule, with help from Mathias Brossard, Amit Langote and
Justin Pryzby.
Reviewed-by: Amit Langote, Mathias Brossard, Melanie Plageman,
Michaël Paquier, Álvaro Herrera

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1c5d9270e339662cdd78d51d0b859d4f0a11aa91

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 33 ++++++
src/bin/psql/command.c | 17 +++
src/bin/psql/describe.c | 214 +++++++++++++++++++++++++++++++++++++
src/bin/psql/describe.h | 3 +
src/bin/psql/help.c | 3 +-
src/bin/psql/tab-complete.c | 27 ++++-
src/test/regress/expected/psql.out | 131 +++++++++++++++++++++++
src/test/regress/sql/psql.sql | 69 ++++++++++++
8 files changed, 495 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-04-07 22:19:34 pgsql: Avoid fetching past the end of the indoption array.
Previous Message Tom Lane 2019-04-07 16:54:47 pgsql: Clean up side-effects of commits ab5fcf2b0 et al.