RE: [GENERAL] insert BLOB - Mailing list pgsql-general

From Nicolas Huillard
Subject RE: [GENERAL] insert BLOB
Date
Msg-id 01BF1670.3416F050@toulouse
Whole thread Raw
In response to [GENERAL] insert BLOB  ("David Lanier" <david@mids.net>)
List pgsql-general
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


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



pgsql-general by date:

Previous
From: "Nikolay Mijaylov"
Date:
Subject: Fw: [GENERAL] Fw: Indexes?!?!? AGAIN!!!!
Next
From: Nicolas Huillard
Date:
Subject: RE: [GENERAL] Another access control query