pgsql批量修改sequences的start方式

修改为指定值

DO $$DECLARE r record;
BEGIN
FOR r IN SELECT sequence_name FROM information_schema.”sequences”
LOOP
EXECUTE ‘ALTER SEQUENCE ‘|| r.sequence_name ||’ restart WITH 10000′;
END LOOP;
END$$;