我写了一个存储不对,帮我改下 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;
就可以导入了
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;