GaussDB查询指定schema下所有表的分布键

select a.rolname,
       a.nspname,
       a.relname,
       a.pclocatortype,
       a.pcattnum,
       a.nodeoids,
       b.column_name
  from (select 
               pr.rolname,
               pn.nspname,
               pc.relname,
               case pxc.pclocatortype
                 when 'H' then 'Hash'
                 when 'G' then 'Range'
                 when 'L' then 'List'
                 when 'R' then 'Replication'
                 else pclocatortype :: text
               end as pclocatortype,
               pxc.pcattnum,
               pxc.nodeoids
          from pg_class pc, pg_roles pr, pg_namespace pn, pgxc_class pxc
         where pc.relowner = pr.oid
           and pc.relnamespace = pn.oid
           and pc.oid = pxc.pcrelid
           and pn.nspname = 'xxx' --指定模式名
           and pc.relkind = 'r'
       ) a,
       adm_tab_columns b
 where a.rolname = b.owner
   and a.relname = b.table_name
   and a.pcattnum :: text = b.column_id
;