From: | Nicolas Huillard <nhuillard(at)ghs(dot)fr> |
---|---|
To: | "'David Lanier'" <david(at)mids(dot)net>, PGSQL-General <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] insert BLOB |
Date: | 1999-10-14 16:12:10 |
Message-ID: | 01BF1670.3416F050@toulouse |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
AFAIK, BLOBs are called "lo" (Large Object) in Postgres
NH
-----Message d'origine-----
De: David Lanier [SMTP:david(at)mids(dot)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
************
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Huillard | 1999-10-14 16:21:09 | RE: [GENERAL] insert BLOB |
Previous Message | Nicolas Huillard | 1999-10-14 16:08:11 | RE: [GENERAL] Another access control query |