Re: plpgsql and COPY

"Joseph Bonnet" <Joseph.Bonnet@Sodebo.fr> writes:
> Y want to use COPY command in a PLpgSQL procedure like this:
> Y have always the response : CopyObjet: don't know to copy 610

Doesn't work in <= 7.0.  Update to 7.1.

If you are going to drop and recreate the table each time, you
might also find that you need to invoke the commands via EXECUTE,
not directly.  Not sure about that.  For utility commands with
no plans, it might work to do it directly as you have here.

            regards, tom lane