Re: Storing jpgs

["Gavin M. Roy" <gmr@ehpg.net>]

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?
>
> I tried to use large objects, but how would you extract them from a 
> table to be viewed in a web-page without having to write them to a 
> scratch file somewhere first?
>
> Thanks
>
> Colin
>
> _________________________________________________________________
> Stay in touch with absent friends - get MSN Messenger 
> http://www.msn.co.uk/messenger
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org