simple example of copying data from a c/c++ array into postgres

"Whit Armstrong" <[email protected]> Tue, 9 Dec 2008 10:08:35 -0500
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <[email protected]>
would someone mind showing me an example of making an insert from binary
data to postgres?
I'm currently doing the inserts via a scripting languge, but I would like to
do them directly in c/c++ code.

my data looks like this (date and double):

2008-12-03         2.6585
2008-12-04         2.5513
2008-12-05         2.7037
2008-12-08         2.7378


my script does something like this:

insert into kls_clnt.obs (id, asofdate, datavalue) values
(100, 2008-12-03, 2.6585);

for every row of the data.

Since, I already have this data in a C array, it must be faster to iterate
through the rows of the array and persist the data directly from C to the
database.   Can someone direct me to a simple example of doing this?

Thanks,
Whit