Re: Blob datatype / image storing

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
>
>
>

In response to

Browse pgsql-general by date

  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