Re: Blob datatype / image storing

ligia,
there is some excellent documentation at any of the mirror sites (or pick up
bruce's book!). the answer to your question is at:

http://www.postgresql.org/idocs/index.php?largeobjects.html

http://www.postgresql.org/idocs/index.php?lo-interfaces.html#AEN15965

reading the blob is another matter. if it's anything like mysql you have to:
- read it into binary;
- write as file of proper type w/ correct file extension;

anyone have any examples of functions that do this?

hope this helps,

chris

"Ligia Pimentel" <lmpimentel@yahoo.com> wrote in message
news:9nqmv5$rks$1@news.tht.net...
> We want to know if is there a datatype for storing images (as a Blob
> datatype)? How do we use it?
>
> Thank you!
>
> Ligia
>
>
>