56,677
社区成员
发帖
与我相关
我的任务
分享
declare table_name varchar(100);
tablename_cursor cursor for select tablename from pg_tables;
sql_1 varchar := '';
begin
open tablename_cursor ;
fetch tablename_cursor into table_name;
if found then
sql_1:='truncate '||table_name;
EXECUTE sql_1;
end if;
close tablename_cursor;
end;