查询Greenplum的视图和存储过程，指定schema

查询视图

SELECT schemaname,viewname AS view_name, definition AS view_definition

FROM pg_views

WHERE schemaname = 'dcf_user';

查询存储过程-查用户所有

SELECT a.proname ,a.prosrc ,b.rolname

FROM pg_proc a

left join pg_roles b on a.proowner =b.oid

where b.rolname = 'dcf_user';

或者-查schma

select b.rolname as schemaname,a.oid::regprocedure as pro_name, a.prosrc as pro_definition from pg_proc a left join pg_roles b on a.proowner =b.oid

where pronamespace=(SELECT oid FROM pg_namespace where nspname ='dcf_user')