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: Blobs in PostgreSQL |
Date: | 2001-06-27 12:43:33 |
Message-ID: | Pine.BSO.4.10.10106270843120.20546-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SQL syntax is fine.
On Wed, 27 Jun 2001, Richard Church wrote:
>
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-06-27 12:47:53 | Re: Binary data Insertion. |
Previous Message | Fariba Noorbakhsh | 2001-06-27 12:10:57 | Re: Questions about triggers,... |