psql \dP: list partitioned tables and indexes

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: 1c5d9270e339662cdd78d51d0b859d4f0a11aa91
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2019-04-07T19:07:21Z
Releases: 12.0
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

Files

PathChange+/−
doc/src/sgml/ref/psql-ref.sgml modified +33 −0
src/bin/psql/command.c modified +17 −0
src/bin/psql/describe.c modified +214 −0
src/bin/psql/describe.h modified +3 −0
src/bin/psql/help.c modified +2 −1
src/bin/psql/tab-complete.c modified +26 −1
src/test/regress/expected/psql.out modified +131 −0
src/test/regress/sql/psql.sql modified +69 −0

Documentation touched