Re: [GENERAL] Can I store bitmap graphics in a table?

From: Henning Hucke <hucke(at)braintec(dot)de>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Can I store bitmap graphics in a table?
Date: 1998-07-28 08:06:59
Message-ID: Pine.LNX.4.00.9807281003490.22847-100000@tea.braintec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)braintec(dot)de Firma BRAINTEC
Borsigstr. 16, 38446 Wolfsburg, Tel. 0 53 61/ 85 51-0

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1998-07-28 08:51:37 Re: [GENERAL] Postgres vs commercial products
Previous Message Bruce Momjian 1998-07-28 07:13:24 Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]