• Michael Paquier's avatar
    Add pg_partition_tree to display information about partitions · d5eec4ee
    Michael Paquier authored
    This new function is useful to display a full tree of partitions with a
    partitioned table given in output, and avoids the need of any complex
    WITH RECURSIVE query when looking at partition trees which are
    deep multiple levels.
    
    It returns a set of records, one for each partition, containing the
    partition's name, its immediate parent's name, a boolean value telling
    if the relation is a leaf in the tree and an integer telling its level
    in the partition tree with given table considered as root, beginning at
    zero for the root, and incrementing by one each time the scan goes one
    level down.
    
    Author: Amit Langote
    Reviewed-by: Jesper Pedersen, Michael Paquier, Robert Haas
    Discussion: https://postgr.es/m/8d00e51a-9a51-ad02-d53e-ba6bf50b2e52@lab.ntt.co.jp
    d5eec4ee
partition_info.out 4.47 KB