| From: | Shelby Cain <alyandon(at)yahoo(dot)com> |
|---|---|
| To: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Bulk updates/inserts |
| Date: | 2004-04-15 04:23:42 |
| Message-ID: | 20040415042342.78626.qmail@web41608.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
--- Christoph Haller <ch(at)rodos(dot)fzk(dot)de> wrote:
>
> There is a way to use COPY programmatically via
> libpq:
>
>
> PQexec("COPY xxx FROM stdin");
> for (...)
> {
> sprintf(buf, "%d\t%d\t...\n",
> values[0], values[1], ... values[n]);
> PQputline(conn, buf);
> }
> PQputline(conn, "\\.\n");
> PQendcopy(conn);
>
> Regards, Christoph
>
Excellent. That'll help reduce my load times. Thanks
for the help.
Regards,
Shelby Cain
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Addington | 2004-04-16 02:35:41 | pl/perl and dynaloader |
| Previous Message | Christoph Haller | 2004-04-14 14:51:31 | Re: Bulk updates/inserts |