Re: BLOBS

Re,
Thinking your create table is off. Sorry for my poor english but try &
practice with this :

Under postgresql user :
psql yourDb

A)
-- ++++++++++++++++++++++++++++++++++
-- CREATION OF TYPE : LO
-- ++++++++++++++++++++++++++++++++++

create type lo (
internallength=4,
externallength=10,
input=int4in,
output=int4out,
default='',
passedbyvalue
);

B) CREATE TABLE ; INSERT BLOB ; SELECT BLOB
IN THIS CASE THE BLOB IS FILE /ETC /FSTAB : SELECT EXPORT THE BLOB IN
/TMP/TOTOFSTAB

CREATE TABLE image (name text, raster oid);
INSERT INTO image (name, raster) VALUES ('toto',lo_import('/etc/fstab'));
SELECT lo_export(image.raster, '/tmp/totofstab') from image WHERE name = 'toto';

C) under your term
more /tmp/totofstab : you'll see your fstab (under Unix like)
==
In my case that works ... and it's on Documentation ;-)
Hope that's help.
Regards.
Emmanuel
===================

Le sam, 05 fv 2000, vous avez crit :
> I am also trying to store word files and images in my postgres database and
> for some reason my create table is giving an error;;
>
> Here is the syntax to create the table:
>
> CREATE TABLE binary_data (id INT4 NOT NULL PRIMARY KEY,client_id
> varchar(50), project_id varchar(50), description CHAR(50), bin_data
> BLOB,filename CHAR(50),filesize CHAR(50),filetype CHAR(50));
>
>
> and here is the error
>
> type name lookup of blob failed
>
> How do you assign a blob to a table? Can you tell me what I am doing wrong?
>
> Thanks,
>
> Ray
>
>
> ---------- Message rachemin ----------
> Subject: Re: [SQL] Blobs
> Date: Mon, 24 Jan 2000 17:07:05 +0100
> From: Compte utilisateur Sultan-advl <webmaster(at)advl(dot)org>
>
>
> You can find this in Postgresql documentation :
> PostgreSQL
> Prev
> Chapter 44. Large Objects
> Built in registered functions
> There are two built-in registered functions, lo_import and lo_export which
> are convenient for use in SQL queries.
> Here is an example of their use
>
> CREATE TABLE image (
> name text,
> raster oid
> );
>
> INSERT INTO image (name, raster)
> VALUES ('beautiful image', lo_import('/etc/motd'));
>
> SELECT lo_export(image.raster, "/tmp/motd") from image
> WHERE name = 'beautiful image';
>
> Regards.
> Emmanuel.
>
>
> Le lun, 24 jan 2000, vous avez crit :
> > >%_Hi Folks
> >
> > I want to store Word docs etc into the mighty Postgres. I think this
> >means using blobs.
> >
> > 1.Does anybody know the SQL to create say a table with a field called
> >docs to store them in. I don't know what the data type is.
> >
> > ie something like CREATE TABLE documents docs (blob datatype ??)
> >
> > 2. Is there some special syntax to get the blob back. ie SELECT (special
> >syntax)
> >
> > Thanks
> >
> > Neil(at)blueice
> >
>
> ---------------------------------
> * Ray Alba/ Electric Web *
> * 55 West 92nd Street *
> * 212.353.7788 *
> * ralba(at)electric-web(dot)com *
> ---------------------------------
--

Emmanuel DISCORS
http://www.advl.org/