On Mon, Sep 28, 2009 at 10:38:05AM -0500, Dave Huber wrote: > Using COPY is out of the question as the file is not formatted for > that and since other operations need to occur, the file needs to be > read sequentially anyway.
Just to expand on what Martin said; if you can generate a set of EXECUTE commands, you can certainly generate a COPY command to insert the same data. The advantage is a large drop in parse time for inserting larger numbers of rows. As you're saying you want to insert 500 rows, I'd suggest at least trying to get COPY working. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
