Re: Need a script that bakes INSERT script from SELECT results - Mailing list pgsql-sql

On Apr 16, 2009, at 7:29 AM, ShuA wrote:

> Could someone post an example how to LOOP through row fields to wrap  
> them into 'VALUES(...,,)' list?


If you declare record or table row types, you can insert the values  
using (rec.*), something like this:


create or replace function test ()
returns void as $$
declarerec record;
beginfor rec in select * from whatever loop    insert into some_table values (rec.*);end loop;
end;
$$ language plpgsql;






John DeSoi, Ph.D.