| From: | "chris_five" <chrisng(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Blob datatype / image storing |
| Date: | 2001-09-14 15:01:12 |
| Message-ID: | YYoo7.10031$jY.224750@news1.rdc1.bc.home.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)yahoo(dot)com> wrote in message
news:9nqmv5$rks$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> We want to know if is there a datatype for storing images (as a Blob
> datatype)? How do we use it?
>
> Thank you!
>
> Ligia
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-09-14 15:12:29 | Re: pg_dump error - LOCALIZATION PROBLEM |
| Previous Message | Andrew Gould | 2001-09-14 14:58:25 | Re: get certain # of recs |