如何查看錶的分布鍵定義和表的分區定義？

\d <table_name>

-- ADB PG 4.3版本

SELECT attname FROM pg_attribute WHERE attrelid='<schema_name>.<table_name>'::regclass and attnum in (SELECT unnest(attrnums) FROM pg_catalog.gp_distribution_policy t WHERE localoid='schemaname.tblname'::regclass);

-- ADB PG 6版本

SELECT attname FROM pg_attribute WHERE attrelid='<schema_name>.<table_name>'::regclass and attnum in (SELECT unnest(distkey) FROM pg_catalog.gp_distribution_policy t WHERE localoid='schemaname.tblname'::regclass);

\d+ <table_name>

SELECT pg_get_partition_def('<schema_name>.<table_name>'::regclass,true);