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(-)