> Is it currently possible to perform bulk
> updates/inserts via host arrays using ecpg? If so,
> would someone mind showing me an example of the proper
> syntax as I can't seem to come up with something that
> the ecpg preprocessor likes.
> On a side note, if ecpg doesn't support bulk
> inserts/updates are there any plans for adding such
> support? Is there anyway programmatically to get
> close to the same speed for inserts/updates as say the
> COPY command?
> Shelby Cain
Doing bulk inserts via host arrays is not possible AFAICT.
I posted a similar request in February 2003.
BTW, I don't see how a bulk update could be done.
There is a way to use COPY programmatically via libpq:
something like ...
PQexec("COPY xxx FROM stdin");
values, values, ... values[n]);
In response to
pgsql-interfaces by date
|Next:||From: Shelby Cain||Date: 2004-04-15 04:23:42|
|Subject: Re: Bulk updates/inserts|
|Previous:||From: brian plummer||Date: 2004-04-13 02:58:32|
|Subject: PostgreSQL: libpq, win32 build|