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