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: | Raw Message | Whole Thread | 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 |