RE: [GENERAL] insert BLOB

No.
You said that BLOB = OID, I said (in another message) that BLOB = LO.
The truth must be somewhere. I think that OID is just some kind of number, that references each object in the database installation.
Maybe David should read the doc...

Nicolas

-----Message d'origine-----
De: Nikolay Mijaylov [SMTP:nmmm(at)nmmm(dot)nu]
Date: jeudi 14 octobre 1999 18:29
À: pgsql-general; Nicolas Huillard
Objet: Re: [GENERAL] insert BLOB

WHY????

because there ;s no KEY??? Ofcource there must be one.... :)

nmmm
----- Original Message -----
From: Nicolas Huillard <nhuillard(at)ghs(dot)fr>
To: 'Nikolay Mijaylov' <nmmm(at)nmmm(dot)nu>; pgsql-general
<pgsql-general(at)postgreSQL(dot)org>; David Lanier <david(at)mids(dot)net>
Sent: 14 Îêòîìâðè 1999 ã. 19:21
Subject: RE: [GENERAL] insert BLOB

Ooops...
It seem that someone is wrong...

-----Message d'origine-----
De: Nikolay Mijaylov [SMTP:nmmm(at)nmmm(dot)nu]
Date: jeudi 14 octobre 1999 17:49
À: pgsql-general; David Lanier
Objet: Re: [GENERAL] insert BLOB

BLOb is OID

CREATE TABLE images (imagefield oid);

----- Original Message -----
From: David Lanier <david(at)mids(dot)net>
To: PGSQL-General <pgsql-general(at)postgreSQL(dot)org>
Sent: 14 Îêòîìâðè 1999 ã. 18:15
Subject: [GENERAL] insert BLOB

> I'm relatively new to Postgres.
>
> I'd like some help setting up a BLOB (binary large object) field to hold
> images, and more importantly, inserting data (images) into it. We're
using
> version 6.5.1.
>
> I tried this:
>
> CREATE TABLE images (imagefield blob);
>
> but I got an error, stating "Unable to locate type name 'blob' in catalog"
>
> Probably a better way to accomplish the same thing is to store the
graphics
> in the file system, and then simply have a column that contains the
location
> (ie http://www.domain.com/images/image1.gif), but I'd still like to know
how
> to place the image itself directly into the database.
>
> Thanks in advance for whatever help any of you can provide.
>
> David
>
>
> ************

************