Re: Blob datatype / image storing - Mailing list pgsql-general

From chris_five
Subject Re: Blob datatype / image storing
Date
Msg-id YYoo7.10031$jY.224750@news1.rdc1.bc.home.com
Whole thread Raw
In response to Blob datatype / image storing  ("Ligia Pimentel" <lmpimentel@yahoo.com>)
List pgsql-general
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
>
>
>



pgsql-general by date:

Previous
From: T.R.Missner@Level3.com
Date:
Subject: how to speed query
Next
From: Robert Grabowski
Date:
Subject: Re: PERL DBD::pg question