检查表是否继承PostgreSQL中的其他表

SELECT
    c.relname AS child_table,
    p.relname AS parent_table
FROM
    pg_inherits AS i
    JOIN pg_class AS c ON i.inhrelid = c.oid
    JOIN pg_class AS p ON i.inhparent = p.oid
ORDER BY
    c.relname;

SELECT
    c.relname AS child_table,
    p.relname AS parent_table
FROM
    pg_inherits AS i
    JOIN pg_class AS c ON i.inhrelid = c.oid
    JOIN pg_class AS p ON i.inhparent = p.oid
WHERE
    c.relname = 'your_table_name'
ORDER BY
    c.relname;