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

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: Dan Delaney <dionysos(at)dionysia(dot)org>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Can I store bitmap graphics in a table?
Date: 1998-07-21 15:18:14
Message-ID: l03110704b1da5f8d4b3d@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 18:04 +0300 on 21/7/98, Dan Delaney wrote:

> That sounds like it might work. I'll give it a try. However, the
> graphics I'm going to be inserting are not very large, like 50 to
> 100k, I'd like to be able to do it without using the large object
> interface. Anyone have any ideas?

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.

Herouth

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gene Selkov, Jr. 1998-07-21 15:34:05 Re: [GENERAL] Postgres superuser priviledges
Previous Message Dan Delaney 1998-07-21 15:04:11 Re: [GENERAL] Can I store bitmap graphics in a table?