Re: [GENERAL] how to use COPY within plperl - Mailing list pgsql-sql

From Marek Lewczuk
Subject Re: [GENERAL] how to use COPY within plperl
Date
Msg-id 418FC58E.1000404@lewczuk.com
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Steven Klassen
Date:
Subject: Re: Hi
Next
From: Kyle
Date:
Subject: Job opportunity