Re: Blobs in PostgreSQL

For which ones?

For bytea fields, you can just use regular functions (substring, etc), and
there's no (well, 2G) limit on size of the field.

For real blobs, its more involved. You are _very strongly suggested_ to
use client-side interfaces, and not SQL interface. (What's the point of
using SQL to fetch a piece of blob on server? What are you going to do
with it? )

On Thu, 28 Jun 2001, Richard Church wrote:

>
> Any examples available, please?
> On all of creating, insertion, updateing, setting it to null?
>
>
> >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: Wed, 27 Jun 2001 08:43:33 -0400 (EDT)
> >
> >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.
>
>