postgresql如何查看某张表的分区情况

说明：通过下面这个SQL，可以查看到postgresql中某张表的分区情况

-- 查看某张表的分区信息
SELECT
    child.relname AS partition_name,
    pg_get_expr(child.relpartbound, child.oid) AS partition_range
FROM
    pg_inherits
        JOIN
    pg_class parent ON pg_inherits.inhparent = parent.oid
        JOIN
    pg_class child ON pg_inherits.inhrelid = child.oid
WHERE
        parent.relname = 'tb_user'
ORDER BY
    partition_range;

首次发布

hezhongying.blog.csdn.net/article/det…