pg库查看某模式下某表的分布键

SELECT 
    aaa.nspname AS "模式名",
    aaa.relname AS "表名",
    ccc.attname AS "分布键"
FROM (
    SELECT 
        aa.oid,
        aa.relname,
        bb.pcattnum,
        dd.nspname
    FROM pg_class aa 
    LEFT JOIN pgxc_class bb ON aa.oid = bb.pcrelid 
    LEFT JOIN pg_namespace dd ON aa.relnamespace = dd.oid
) aaa
LEFT JOIN pg_attribute ccc ON ccc.attrelid = aaa.oid AND ccc.attnum = aaa.pcattnum
WHERE ccc.attnum > 0
AND aaa.nspname = '模式名'
and aaa.relname = '表名'
ORDER BY aaa.relname