Reid Thompson wrote:
> 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.
>
Thanks for the sample. I will be using Hibernate with will make my code
much cleaner. I will post an example here when done. I never use
straight JDBC.