create or replace procedure del_data_gt_6_months() as
$$
declare
my_tablename record ;
tablename_cur cursor for select tablename from pg_tables where tablename like 'dds%';
begin
for my_tablename in tablename_cur loop
execute format('delete from %I where time < %L ::date;',my_tablename.tablename,'2021-07-01');
end loop;
end;
$$LANGUAGE plpgsql;
postgres批量删除多表数据的一个存储过程
最新推荐文章于 2023-12-09 11:01:59 发布