]> granicus.if.org Git - postgresql/commit
psql \dP: list partitioned tables and indexes
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Sun, 7 Apr 2019 11:59:12 +0000 (07:59 -0400)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Sun, 7 Apr 2019 19:07:21 +0000 (15:07 -0400)
commit1c5d9270e339662cdd78d51d0b859d4f0a11aa91
treeff2f59ecd3e90c999f081121748b44ab1400804c
parent159970bcadbbdefd312d75ce7ad90f19add19b40
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
doc/src/sgml/ref/psql-ref.sgml
src/bin/psql/command.c
src/bin/psql/describe.c
src/bin/psql/describe.h
src/bin/psql/help.c
src/bin/psql/tab-complete.c
src/test/regress/expected/psql.out
src/test/regress/sql/psql.sql