-
换我堕落ミ
发布于 2020-12-29 10:03
-
收藏
修改为指定值DO $$DECLARE r record;BEGINFOR r IN SELECT sequence_name FROM information_schema."sequences"LOOP EXECUTE 'ALTER SEQUENCE '|| r.sequence_name ||' restart WITH 10000';END LOOP;END$$;根据表的id修改DO $$DECLAREr record; st..