Re: Blobs in PostgreSQL

From: Gunnar Rønning <gunnar(at)polygnosis(dot)com>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: Richard Church <rfchurch(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Blobs in PostgreSQL
Date: 2001-06-27 07:12:04
Message-ID: m21yo6flbv.fsf@smaug.polygnosis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Alex Pilosov <alex(at)pilosoft(dot)com> wrote:
|
|
| b) the above is rarely necessary now, that there is no limit on amount of
| data you can put into one tuple (due to TOASTing of tuples). To store
| binary data, you should use bytea type and it has infinite (well, 4G)
| limit of data.

Well, the bytea datatype is not supported by the JDBC driver.
Also it is not documented in the datatype section of the manual.

--
Gunnar Rønning - gunnar(at)polygnosis(dot)com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor 2001-06-27 09:02:42 How to join tables with different columns and different number of rows?
Previous Message Richard Huxton 2001-06-27 07:11:00 Re: Complicated query... is there a simpler way?