1.查询表结构
/d pg_catalog.pg_proc;
2.查询存储过程
select proname,prosrc from pg_catalog.pg_proc where proname like 'sp_%';
3.动态存储过程调用
CREATE OR REPLACE PROCEDURE sp_test1
(
param1 in INTEGER,
param2 out INTEGER,
param3 in INTEGER
)
AS
BEGIN
param2:=param1+param3;
END;
/
DECLARE