Re: [GENERAL] how to use COPY within plperl

Goutam Paruchuri wrote:
> Why can you not use simple insert statements (sql insert).
> Copy is meant to transfer large amount of data from text files to
> databases and vice versa.
"Insert" is much slower if there are many (hundreds, thousands) data to
be inserted - and in my case there will be thousands of inserts made by
plperl. I can make a file with the data (and load using COPY), but it
would be better to use copy from stdin.

Thanks

ML



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org