Re: [GENERAL] Storing jpgs

[Joe Lester]

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