查询Greenplum下一个schema中表的owner

查询一个schema下表及其owner：

select c.relname,  pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
from pg_catalog.pg_class c, pg_catalog.pg_namespace n
where
n.oid = c.relnamespace
and n.nspname='schema_name'
and  c.relkind='r'  and relstorage in ('h', 'a');