Postgresql等价的FORALL语法

Question

请分享以下语句在postgresql中的等价语法

FORALL i IN 1..20
   INSERT INTO emp2 VALUES (enums(i));

Answer 1

尝试:

INSERT INTO emp2
 SELECT * FROM generate_series(1,20);