以下sql是取A表的值动态赋给B表
do language plpgsql $$
declare
userid varchar;
begin
for i in 101..105 loop
select filed from A where (条件查询) limit 1 offset i into userid ;
INSERT INTO B
(filed1,filed2)
VALUES(i,userid);
END LOOP;
end $$;