>> At the moment libpq doesn't seem to support asynchronous and >> non-blocking support for large objects, in the style of >> PQsendQuery/PQgetResult. This makes large objects hardly suited for >> single-threaded programs based on some variant of select(). >> > According to http://www.postgresql.org/docs/9.2/static/lo-funcs.html > "There are server-side functions callable from SQL that correspond to each > of > the client-side functions". Hence, you can call these functions by using > asynchronous API.
Thanks, I'll try this way (BTW, it may help to specify on the documentation that lo_read and lo_write lose the "_"). I wonder whether having to escape all the content for lowrite can't have a negative impact on performances. It shouldn't be too bad for my case, though.
You may avoid escaping bytea data by using PQsendPrepare,
PQsendQueryPrepared specifying binary data format.