greenplum查询元信息
1.普通表
select * from pg_tables
2.所有表,包括外部表
select * from information_schema.tables
3.统计表占用空间大小
select pg_size_pretty(pg_total_relation_size('xxx'))
4.统计某个schema占用空间(GB)
select sum(pg_total_relation_size(schemaname||'.'||tablename))/