Wiki / psql Commands / Describe database objects
\dP
Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned t…
Reading PostgreSQL 18.6.
Description
Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed.
- Client
- psql 18.6
- Case-sensitive spelling
- \dP
Usage
\dP[itnx+] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dP | itnx+ |
Manual definition
\dP[itnx+] [pattern]-
Lists partitioned relations. If
patternis specified, only entries whose name matches the pattern are listed. The modifierst(tables) andi(indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed.If the modifier
n(“nested”) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation.If
xis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. Ifnis combined with+, two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: changed.
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
{
- "definition": "Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed. If the modifier n ( “ nested ” ) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation. If + is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. If n is combined with + , two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.",
+ "definition": "Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed. If the modifier n ( “ nested ” ) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. If n is combined with + , two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.",
"modifiers": [
{
"command": "\\dP",
- "modifiers": "itn+"
+ "modifiers": "itnx+"
}
],
- "signature": "\\dP[itn+] [ pattern ]",
+ "signature": "\\dP[itnx+] [ pattern ]",
"spellings": [
"\\dP"
]Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 12 through 20; the first sample is not necessarily its introduction.