Re: [SQL] [GENERAL] how to use COPY within plperl

2004-11-13 Thread Goutam Paruchuri
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. - Goutam > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk > Sent: Monday, Novembe

Re: [SQL] [GENERAL] how to use COPY within plperl

2004-11-08 Thread Marek Lewczuk
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 thousand