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):
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?
pgsql-interfaces by date
|Next:||From: Jeroen Vermeulen||Date: 2008-12-09 16:53:05|
|Subject: Re: simple example of copying data from a c/c++ array
|Previous:||From: Haszlakiewicz, Eric||Date: 2008-12-03 21:27:47|
|Subject: Re: deallocating prepared statements|