Re: Storing jpgs

[Joe Lester <joe_lester@sweetwater.com>]

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?



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org