select * from pg_proc;//查看所有的存储过程 select procname, prosrc from pg_proc where proname = 'function_name'; //查看function_name 的创建语句