in reply to Re: blob field
in thread blob field

I've had good luck storing images in a PostgreSQL database using the bytea data type. Take a look at the bind_param section of DBD::Pg for more details on how to do it.

As a handy trick for pulling the images back out and displaying them without knowing the file extension, use File::MMagic to figure out the what kind of image it is. I used this to specify the header type on a CGI application that retrieved stored images.

However, if you're going to be storing a lot of images or speed is a concern, you're probably better off following amt's advice.