From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
---|---|
To: | Henning Hucke <hucke(at)braintec(dot)de> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Can I store bitmap graphics in a table? |
Date: | 1998-07-28 09:21:13 |
Message-ID: | l03110702b1e34833a79c@[147.233.159.109] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-07-28 11:46:14 | Re: [GENERAL] Postgres vs commercial products |
Previous Message | Herouth Maoz | 1998-07-28 08:51:37 | Re: [GENERAL] Postgres vs commercial products |