Importing blob

From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Importing blob
Date: 2002-08-07 05:46:07
Message-ID: 4165C48DE9A0D211B6400800095C585F172DF5@WASHINGTON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is my table:

CREATE TABLE setimg (id serial, setid int8, image OID);

Here is my insert:

INSERT INTO setimg(setid, image) VALUES ('32334', lo_import('32334.jpg'));

And the error:

lo_import: can't open unix file "32334.jpg": no such file or directory

I have tried everything that I can think of to insert this file and every
time I get the same error. I have set the full path to the file. I have
change priv to 666. Confirmed proper ownership <user>:<user>. And still it
does not see it. What am I doing wrong?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Nelson 2002-08-07 06:00:47 Re: Importing blob
Previous Message Trey Ackerman 2002-08-07 05:03:55 looking to speed up SELECT ... LEFT JOIN query