From: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl> |
---|---|
To: | Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: simple example of copying data from a c/c++ array into postgres |
Date: | 2008-12-09 16:53:05 |
Message-ID: | 493EA271.8010209@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Haszlakiewicz, Eric | 2008-12-09 17:26:52 | Re: simple example of copying data from a c/c++ array into postgres |
Previous Message | Whit Armstrong | 2008-12-09 15:08:35 | simple example of copying data from a c/c++ array into postgres |