greenplum使用SQL查看存储过程

SELECT
  n.nspname AS schema_name, -- 所属模式
  p.proname AS procedure_name, -- 存储过程名
  l.lanname AS language, -- 编写语言（如plpgsql）
  pg_get_function_arguments(p.oid) AS arguments, -- 参数列表
  pg_get_functiondef(p.oid) AS definition -- 完整定义
FROM
  pg_proc p
INNER JOIN pg_namespace n 
  ON p.pronamespace = n.oid
INNER JOIN pg_language l 
  ON p.prolang = l.oid
WHERE
  n.nspname NOT LIKE 'pg_%' -- 排除系统内置
  AND n.nspname != 'information_schema'
  AND p.proname like '%sp_fssc_calc_worktime%';