Re: Blobs in PostgreSQL

There are many things one may mean by blob.
a) there's old 'large object' interface,
http://www.postgresql.org/idocs/index.php?largeobjects.html

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.

On Wed, 27 Jun 2001, Richard Church wrote:

>
> It seems that PostgreSQL supports Blobs but I couldn't find any mention of
> it in the data types section of the manual.
>
> Is it a variant on the Text type, or is it entirely different?
>
> Where in the manual is it described?
>
>
> Richard
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>