你试一下应该和pg是一样的

• \d

\d+
复制

• 查询指定分区表信息

SELECT

    nmsp_parent.nspname AS parent_schema ,

    parent.relname AS parent ,

    nmsp_child.nspname AS child ,

    child.relname AS child_schema

FROM

    pg_inherits JOIN pg_class parent

        ON pg_inherits.inhparent = parent.oid JOIN pg_class child

        ON pg_inherits.inhrelid = child.oid JOIN pg_namespace nmsp_parent

        ON nmsp_parent.oid = parent.relnamespace JOIN pg_namespace nmsp_child

        ON nmsp_child.oid = child.relnamespace

WHERE

    parent.relname = 'table_name';
复制

• 查询库中所有分区表子表个数

SELECT

    nspname ,

    relname ,

    COUNT(*) AS partition_num

FROM

    pg_class c ,

    pg_namespace n ,

    pg_inherits i

WHERE

    c.oid = i.inhparent

    AND c.relnamespace = n.oid

    AND c.relhassubclass

    AND c.relkind = 'r'

GROUP BY 1,2 ORDER BY partition_num DESC;

复制