[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Can I store bitmap graphics in a table?
From:       Herouth Maoz <herouth () oumail ! openu ! ac ! il>
Date:       1998-07-28 9:21:13
[Download RAW message or body]

At 11:06 +0300 on 28/7/98, Henning Hucke wrote:


>
> > [... Storing graphics in a postgresql db ...]
> > You can't. There is a limit on the tuple size, restricting it to 8k. If you
> > could guarantee that your images are no more than, say, 1K - I'd say you
> > can uuencode them or translate to hex, and put it in a text column. A byte
> > array is another option. But in the 50k to 100k, it's large objects.
>
> Even without having tried it I am rather shure that you are wrong. The 8k
> barrier applies AFAIK only to the normal datatypes like text and so. AFAIK
> the LOI is capable to store big graphics in the database.

Well, he asked for a way to do it as a normal datatype, without using the
(awkward) lo interface. Of course you can do it with LOs.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

[prev in list] [next in list] [prev in thread] [next in thread]