On Tue, 2009-01-13 at 18:22 -0600, Jason Long wrote:
> Never used Python or Perl. I use primarily Java. I was thinking of
> doing something like
> INSERT INTO pictures (filename,data) VALUES ('filename','/path/to/my/image/img0009.jpg');
>
> But, this syntax doesn't seem to be supported.
>
> Maybe I can use a custom C function to get the contents of the file. Then do something like
>
> INSERT INTO pictures (filename,data) VALUES ('/path/to/my/image/img0009.jpg',getBinaryFileContents('/path/to/my/image/img0009.jpg'));
>
> Is there some postgres contrib for something like this?
>
>
>
>
Simple java stub test program attached. Modify to meet your needs. See
file header for URL of original example.