当前位置：网站首页>PG library to view the distribution keys of a table in a certain mode

PG library to view the distribution keys of a table in a certain mode

2022-04-23 13:41:00 【Wangcai 2】

SELECT
aaa.nspname AS " Schema name ",
aaa.relname AS " Table name ",
ccc.attname AS " Distribution keys "
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 = ' Schema name '
and aaa.relname = ' Table name '
ORDER BY aaa.relname