[大数据]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

阅读世界，共赴山海

423全民读书节，邀你共读