Thread: Blob datatype / image storing
We want to know if is there a datatype for storing images (as a Blob datatype)? How do we use it? Thank you! Ligia
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 > > >