Thread: [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
){kind=link}
BLOb is OID CREATE TABLE images (imagefield oid); ----- Original Message ----- From: David Lanier <david@mids.net> To: PGSQL-General <pgsql-general@postgreSQL.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 > > > ************
AFAIK, BLOBs are called "lo" (Large Object) in Postgres NH -----Message d'origine----- De: David Lanier [SMTP:david@mids.net] Date: jeudi 14 octobre 1999 17:15 À: PGSQL-General Objet: [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 ************
Ooops... It seem that someone is wrong... -----Message d'origine----- De: Nikolay Mijaylov [SMTP:nmmm@nmmm.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@mids.net> To: PGSQL-General <pgsql-general@postgreSQL.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 > > > ************ ************
WHY???? because there ;s no KEY??? Ofcource there must be one.... :) nmmm ----- Original Message ----- From: Nicolas Huillard <nhuillard@ghs.fr> To: 'Nikolay Mijaylov' <nmmm@nmmm.nu>; pgsql-general <pgsql-general@postgreSQL.org>; David Lanier <david@mids.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@nmmm.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@mids.net> To: PGSQL-General <pgsql-general@postgreSQL.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 > > > ************ ************
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@nmmm.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@ghs.fr> To: 'Nikolay Mijaylov' <nmmm@nmmm.nu>; pgsql-general <pgsql-general@postgreSQL.org>; David Lanier <david@mids.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@nmmm.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@mids.net> To: PGSQL-General <pgsql-general@postgreSQL.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 > > > ************ ************