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 f�v 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 r�achemin� ----------
> Subject: Re: [SQL] Blobs
> Date: Mon, 24 Jan 2000 17:07:05 +0100
> From: Compte utilisateur Sultan-advl <webmaster@advl.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@blueice
> >
>
> ---------------------------------
> * Ray Alba/ Electric Web *
> * 55 West 92nd Street *
> * 212.353.7788 *
> * ralba@electric-web.com *
> ---------------------------------
--
Emmanuel DISCORS
http://www.advl.org/
