Re: [GENERAL] Can I store bitmap graphics in a table? - Mailing list pgsql-general

From Henning Hucke
Subject Re: [GENERAL] Can I store bitmap graphics in a table?
Date
Msg-id Pine.LNX.4.00.9807281003490.22847-100000@tea.braintec.de
Whole thread Raw
In response to Re: [GENERAL] Can I store bitmap graphics in a table?  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Responses Re: [GENERAL] Can I store bitmap graphics in a table?  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-general
On Tue, 21 Jul 1998, Herouth Maoz 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.

With best regards
             Henning Hucke
--
hucke@braintec.de                      Firma BRAINTEC
Borsigstr. 16, 38446 Wolfsburg, Tel. 0 53 61/ 85 51-0


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Postgres vs commercial products