Re: Storing jpgs - Mailing list pgsql-general

From Joe Lester
Subject Re: Storing jpgs
Date
Msg-id 7CC268AD-87D6-11D8-B5F2-000A95A58EA0@sweetwater.com
Whole thread Raw
In response to Re: Storing jpgs  ("Gavin M. Roy" <gmr@ehpg.net>)
Responses Re: Storing jpgs
Re: Storing jpgs
List pgsql-general
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?



pgsql-general by date:

Previous
From: Ericson Smith
Date:
Subject: Re: Large DB
Next
From: Tom Lane
Date:
Subject: Re: Crash in postgres/linux on verly large database