| From: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
|---|---|
| To: | Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>, Lista dyskusyjna pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | how to use COPY within plperl |
| Date: | 2004-11-08 08:59:00 |
| Message-ID: | 418F3554.8090209@lewczuk.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hello,
I need to use COPY (instead of INSERT) within plperl function. I know
that COPY will work if data will be taken from file - however I need to
use STDIN. I tried this:
spi_exec_query("COPY sometable (field1, field2) FROM
stdin;"."\n"."sometext"."\t"."sometext"."\n"."\.")
But it didn't work. Thanks in advance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-11-08 09:02:36 | Re: Avoiding explicit addDataType calls for PostGIS |
| Previous Message | Johan Wehtje | 2004-11-08 08:50:47 | Re: Visual DATA MODEL Designer in linux? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaare Rasmussen | 2004-11-08 09:36:52 | Re: Scheduling Jobs In PostgreSQL |
| Previous Message | Christopher Browne | 2004-11-08 04:17:26 | Re: Scheduling Jobs In PostgreSQL |