Re: Blobs in PostgreSQL - Mailing list pgsql-general

From Richard Church
Subject Re: Blobs in PostgreSQL
Date
Msg-id F57ryKFRJrzdDW6lCPx00006aee@hotmail.com
Whole thread Raw
In response to Blobs in PostgreSQL  ("Richard Church" <rfchurch@hotmail.com>)
Responses Re: Blobs in PostgreSQL  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
Any examples available, please?
On all of creating, insertion, updateing, setting it to null?


>From: Alex Pilosov <alex@pilosoft.com>
>To: Richard Church <rfchurch@hotmail.com>
>CC: pgsql-general@postgresql.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@pilosoft.com>
> > >To: Richard Church <rfchurch@hotmail.com>
> > >CC: pgsql-general@postgresql.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.


pgsql-general by date:

Previous
From: John Clark Naldoza y Lopez
Date:
Subject: Re: Re: Red Hat to support PostgreSQL
Next
From: John Clark Naldoza y Lopez
Date:
Subject: Re: Re: Red Hat to support PostgreSQL