At 08:48 PM 11-03-2001 -0500, Tom Lane wrote:
><drevil@sidereal.kz> writes:
>> I would like to store some images in my Postgres database. These will
>> all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row
>
>bytea is probably your best bet. The 8k limit is toast in 7.1, btw.
What's bytea ?
How do I store and retrieve 0x00 and other binary stuff like this?
Right now I store stuff like this in files on the filesystem. Storing as
base64 in text doesn't sound attractive :). What are the advantages of
using BLOBs vs files on the filesystem?
Cheerio,
Link.