Re: Dynamic prepare possible in plpgsql?

I have a plpgsql function which is doing a loop over one table of user
data and then inserting that data in various tables. Example:

loop over user table (temp data)
insert into users1 table
insert into users2 table
etc....
end loop

Is it faster to use PREPARE for the various INSERT statements inside a
plpgsql function? Perhaps I am wrong and it does its PREPARE work
when the function is parsed.

Collin

On 4/30/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Collin Peters" <cadiolis(at)gmail(dot)com> writes:
> > Is it possible to have a dynamic PREPARE statement in plpgsql?
>
> Well, you could use plpgsql's EXECUTE to run SQL PREPARE and EXECUTE
> commands, but it seems awfully brute-force. What do you really need
> to accomplish here?
>
> regards, tom lane
>