drop table t2; create table t2(num1 integer, num2 integer, data text); create or replace function insert092() returns void as $$ begin for i in 1..9 loop for j in 1..9 loop insert into t2 values(i, j, 'DATA_' || i || '_' || j); end loop; end loop; return; end; $$ language plpgsql;