可以根据几个常用的视图来查看权限是否上付完成：pg_tables表的基本信息，pg_database数据库的基本信息，information_schema.table_privileges表的基本信息，pg_role用户的基本信息。一般所有的权限都可以在这个上边查看。也可以两个或者几个视图联合查看：select a.datname,b.rolname,string_agg(a.pri_t,',') from  (select datname,(aclexplode(COALESCE(datacl, acldefault('d'::"char",datdba)))).grantee as grantee,    (aclexplode(COALESCE(datacl, acldefault('d'::"char",datdba)))).privilege_type as pri_t from pg_database where datname not like 'template%') a,pg_roles b where (a.grantee = b.oid or a.grantee = 0)and b.rolname='user1' group by a.datname,b.rolname;

可以使用：select b.relname,a.nodeoidsfrom PGXC_CLASS ajoin PG_CLASS bon a.pcrelid = b.oidand b.relname = 'table1';查看表所分布在那个节点上，查看节点的oid。也可以直接使用视图查看分区表的基本信息：SELECT relname, boundaries FROM pg_partition WHERE parentid = 'table1'::regclass AND parttype = 'p' ORDER BY 1;也可以在系统上层查看分区表的信息：select pc.relname,pxc.nodeoids,pn.*from pg_class pc,pgxc_class pxc,pgxc_node pnwhere pc.oid = pxc.pcrelidand cast(pxc.nodeoids as varchar) = cast(pn.oid as varchar)and pc.relname = 'table1';

谢谢分享

谢谢分享