-- 创建一个存储过程
CREATE OR REPLACE PROCEDURE "来源链接处理"("批次" varchar='xxxxxxxx'::character varying)
AS $BODY$
DECLARE sqlstring VARCHAR;
BEGIN
-- Routine body goes here...
sqlstring:='DROP TABLE IF EXISTS be_yaopinzhongbiao_url'||批次||';';
RAISE NOTICE '即将执行SQL语句%' ,sqlstring;
EXECUTE sqlstring;
sqlstring:='CREATE TABLE be_yaopinzhongbiao_url'||批次||' AS(
SELECT
me_approvaldate,
me_source,
me_down
FROM
be_yaopinzhongbiao
GROUP BY
me_approvaldate,
me_source,
me_down
);';
RAISE NOTICE '即将执行SQL语句%' ,sqlstring;
EXECUTE sqlstring;
RAISE NOTICE '已创建创建表:be_yaopinzhongbiao_url%', 批次;
END$BODY$
LANGUAGE plpgsql;
CALL "来源链接处理"('20190702');