-- 创建一个存储过程
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_'||批次||';';
RAISE NOTICE '即将执行SQL语句%' ,sqlstring;
EXECUTE sqlstring;
sqlstring:='CREATE TABLE be_yaopinzhongbiao_'||批次||' AS(
SELECT
*
FROM
be_yaopinzhongbiao
);';
RAISE NOTICE '即将执行SQL语句%' ,sqlstring;
EXECUTE sqlstring;
RAISE NOTICE '已创建创建表:be_yaopinzhongbiao_%', 批次;
END$BODY$
LANGUAGE plpgsql;
CALL "中标数据备份"('20190702');