diff options
author | Michael Paquier <michael@paquier.xyz> | 2019-02-08 08:56:14 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2019-02-08 08:56:14 +0900 |
commit | 3677a0b26bb2f3f72d16dc7fa6f34c305badacce (patch) | |
tree | a46ee2b807265d8f0c899c53f1bad3bebec67b34 /doc/src | |
parent | 34ea1ab7fd305afe1124a6e73ada0ebae04b6ebb (diff) | |
download | postgresql-3677a0b26bb2f3f72d16dc7fa6f34c305badacce.tar.gz postgresql-3677a0b26bb2f3f72d16dc7fa6f34c305badacce.zip |
Add pg_partition_root to display top-most parent of a partition tree
This is useful when looking at partition trees with multiple layers, and
combined with pg_partition_tree, it provides the possibility to show up
an entire tree by just knowing one member at any level.
Author: Michael Paquier
Reviewed-by: Álvaro Herrera, Amit Langote
Discussion: https://postgr.es/m/20181207014015.GP2407@paquier.xyz
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4930ec17f62..86ff4e5c9e2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -20274,6 +20274,17 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup()); their partitions, and so on. </entry> </row> + <row> + <entry> + <indexterm><primary>pg_partition_root</primary></indexterm> + <literal><function>pg_partition_root(<type>regclass</type>)</function></literal> + </entry> + <entry><type>regclass</type></entry> + <entry> + Return the top-most parent of a partition tree to which the given + relation belongs. + </entry> + </row> </tbody> </tgroup> </table> |