Any examples available, please? On all of creating, insertion, updateing, setting it to null? >From: Alex Pilosov <[EMAIL PROTECTED]> >To: Richard Church <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >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 <[EMAIL PROTECTED]> > > >To: Richard Church <[EMAIL PROTECTED]> > > >CC: [EMAIL PROTECTED] > > >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 [EMAIL PROTECTED]