Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group