From: | "Richard Church" <rfchurch(at)hotmail(dot)com> |
---|---|
To: | alex(at)pilosoft(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Blobs in PostgreSQL |
Date: | 2001-06-27 11:12:03 |
Message-ID: | F262vtXSi9Kl4sidKKx00005c34@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can it be created and manipulated using the SQL syntax, or does it require
using the C language interface?
>From: Alex Pilosov <alex(at)pilosoft(dot)com>
>To: Richard Church <rfchurch(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Blobs in PostgreSQL
>Date: Tue, 26 Jun 2001 22:22:29 -0400 (EDT)
>
>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(at)postgresql(dot)org
> >
> >
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Edmund von der Burg | 2001-06-27 11:41:27 | A way of storing variables - will this work? |
Previous Message | Martijn van Oosterhout | 2001-06-27 10:45:20 | Re: How to join tables with different columns and different number of rows? |