| From: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
|---|---|
| To: | Goutam Paruchuri <gparuchuri(at)oneil(dot)com> |
| Cc: | Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>, Lista dyskusyjna pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: how to use COPY within plperl |
| Date: | 2004-11-08 19:14:22 |
| Message-ID: | 418FC58E.1000404@lewczuk.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-11-08 19:15:39 | Re: index not always used when selecting on a date field |
| Previous Message | Goutam Paruchuri | 2004-11-08 19:04:00 | Re: how to use COPY within plperl |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyle | 2004-11-08 23:29:08 | Job opportunity |
| Previous Message | Goutam Paruchuri | 2004-11-08 19:04:00 | Re: how to use COPY within plperl |