On Tue, Jul 03, 2001 at 08:56:20PM -0700, Scott Holmes wrote:
> Perhaps someone can point me towards what I'm missing. I've included my make
> command, the command for creating a function and the actual code I wrote
> (derived from the sample code in the docs). Incidentally, this project is too
> far along to change to java or any other interface. I currently am handling
> the files to be lo's as system files but the request is in to save them as
> blobs.
You've written a client-side program, but are trying to use it as a
server side function. I don't think that'll work. You don't want to be
using libpq for server side functions. I don't know the Java interface, but
it seems you are trying to do what is already available via
lo_import/lo_export functions. Maybe you could explain the interface
you need a little better. Is it not possible to use the lo_import() and
lo_export functions that are already available? (Why they are hidden in
the Programmer's Guide is beyond me...).
SELECT lo_export (<table>.<column>, '/path/to/file') from <table>;
INSERT INTO <table> (<column>) VALUES (lo_import ('/path/to/file'));
Someone recently suggested using bytea fields for blobs as well...
--
Eric G. Miller <egm2@jps.net>