PGsql实现循环插入查询出的数据_pgsql循环插入数据

PGsql实现循环插入查询出的数据

do $$
declare 
	tmp record;

ia int := 1;

ib int := 2;

ic int := 3;

begin
   for tmp in (
select
	*
from
	xxx_table xxx
join position p 
on xxx.position_id = p.id
)   
	loop
		
insert
	into
	management_position_user 
	(position_id,user_id)
values
(tmp.position_id,
tmp.user_id);

raise notice 'position_id:%, user_id:%',
tmp.position_id,
tmp.user_id;
end loop;
end;

$$
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36