Message-ID: <493EA271.8010209@xs4all.nl>
Date: Tue, 09 Dec 2008 23:53:05 +0700
From: Jeroen Vermeulen <jtv@xs4all.nl>
User-Agent: Thunderbird 2.0.0.18 (X11/20081125)
MIME-Version: 1.0
To: Whit Armstrong <armstrong.whit@gmail.com>
CC: pgsql-interfaces@postgresql.org
Subject: Re: simple example of copying data from a c/c++ array
 into postgres
References: <8ec76080812090708g93000f9l7e7f3e2162587331@mail.gmail.com>
In-Reply-To: <8ec76080812090708g93000f9l7e7f3e2162587331@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Whit Armstrong wrote:
> would someone mind showing me an example of making an insert from binary 
> data to postgres?

Not an example, but have a look at the COPY command:

http://www.postgresql.org/docs/8.3/interactive/sql-copy.html

COPY FROM stdin lets you insert data in bulk, without having to issue a 
new INSERT for every row.  There are some handy libpq functions for 
feeding data into this mechanism:

http://www.postgresql.org/docs/8.3/interactive/libpq-copy.html

The "binary" part of what you're asking for is also possible, but 
probably doesn't buy you all that much.  Chances are you'd need to do 
some conversions anyway, and it introduces all sorts of maintenance risk 
for an optimization that's not likely to matter as much as disk flushes, 
network transfers etc.


Jeroen