Howto use "COPY FROM" with the native API? - Mailing list pgsql-general

From Clemens Eisserer
Subject Howto use "COPY FROM" with the native API?
Date
Msg-id BANLkTimXyVdvncwJJzxeFqrYSq6obYPO6w@mail.gmail.com
Whole thread Raw
Responses Re: Howto use "COPY FROM" with the native API?
Re: Howto use "COPY FROM" with the native API?
List pgsql-general
Hi,

We are working on an university project for network traffic accounting.
We use ulogd-2 to log netfilter packets, however it creates for each
packet a seperate transaction and also doesn't use prepared
statements, which results in horrible performance.

What we are looking for is a low-overhead way of inserting many rows
(100-1000) into a table at once in one transaction.
Is "COPY FROM STDIN"  a good idea in this case?

If so, are there some examples how to use "COPY FROM STDIN" with the
native C API?
I found some documentation, however as I am no C native some sample
code would really help.

Thank you in advance, Clemens

PS: Sorry for the cross post, I accidentially sent it to the jdbc list before.

pgsql-general by date:

Previous
From: George Woodring
Date:
Subject: Re: autovacuum issue after upgrade to 9.0.1
Next
From: manuel antonio ochoa
Date:
Subject: PG 9.0 32 bits bin under 64 bit arq