Re: Blobs in PostgreSQL - Mailing list pgsql-general

From Gunnar Rønning
Subject Re: Blobs in PostgreSQL
Date
Msg-id m21yo6flbv.fsf@smaug.polygnosis.com
Whole thread Raw
In response to Re: Blobs in PostgreSQL  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: Blobs in PostgreSQL  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
* Alex Pilosov <alex@pilosoft.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@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

pgsql-general by date:

Previous
From: Ryan Mahoney
Date:
Subject: Re: Complicated query... is there a simpler way?
Next
From: Richard Huxton
Date:
Subject: Re: Bug in createlang?