PostgreSQL查函数详情

---

SELECT pn.nspname AS schema_name
      ,pc.proname as "函数名"
      ,pc.proargnames "函数参数"
      ,pg_get_functiondef(pc."oid") as "函数内容"
  FROM pg_proc pc
  JOIN pg_namespace pn ON ( pc.pronamespace = pn.oid ) 
where  pn.nspname NOT IN ('pg_catalog','public','information_schema','root','adms_oracle_ext')
 order by schema_name,"函数名","函数参数";