Re: Storing jpgs

Would anyone have some example code they could share using libpq to
encode an image into a text field? Right now, I'm converting my image
into a hexadecimal string representation in my SQL statement. I'm sure
there must be a better (faster) way. The hex encodeing/decoding slows
things down for me since my app deals with a lot of images.

On Apr 5, 2004, at 2:03 PM, Gavin M. Roy wrote:

> I'm one for using base64 encoded text in a text field. It's easy to
> deal with queries, it's easy to deal with spitting out images, and
> it's easy to back up. Others do it differently, there are many ways
> to skin a cat, and each person who skins cats most likely thinks their
> way is best.
> Gavin
>
> C G wrote:
>
>> Dear All,
>>
>> What's the best way to store jpgs in postgresql to use in a web page?