-----Original Message----- From: John DeSoi <de...@pgedit.com> To: ShuA <nof...@inbox.ru> Date: Thu, 16 Apr 2009 08:25:15 -0400 Subject: Re: [SQL] Need a script that bakes INSERT script from SELECT results
> 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 $$ > declare > rec record; > begin > for rec in select * from whatever loop > insert into some_table values (rec.*); > end loop; > end; > $$ language plpgsql; > > John DeSoi, Ph.D. The functionality I need is about to replicate table data into remote DB. > for rec in select * from whatever loop > insert into some_table values (rec.*); > end loop; ^^^ that is not my case, unfortunately. The next, what is supposed to do with baked INSERT statements, is push them thru dblink_exec(), as text param, to make insert works on remote DB. Olksy -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
