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(at)braintec(dot)de Firma BRAINTEC
Borsigstr. 16, 38446 Wolfsburg, Tel. 0 53 61/ 85 51-0