drop table t1; create table t1(num integer, data text); create or replace function insert091() returns void as $$ begin for i in 1..9 loop insert into t1 values(i, 'DATA_' || i); end loop; return; end; $$ language plpgsql;