PostgreSQL存储过程-中标数据处理-表格备份

	-- 创建一个存储过程
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');