| From: | sibusiso xolo <sibxol(at)b-vol(dot)co(dot)uk> |
|---|---|
| To: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | problems retrieving images in 7.3.4 |
| Date: | 2003-10-08 17:11:05 |
| Message-ID: | 200310081811.05715.sibxol@b-vol.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings,
I am new to this list. I have a problem with BLOBS using PostgreSQL7.3.4.
I used the lo_export utility to insert an image into a trial database. I have
not been able to use the lo_export utility to retrieve it. I have done this
successfully before using PostgreSQL7.2.
Assuming I have a table name TABLE with columns named TITLE and IMAGE. I (
working as postgres ) issued the following select statement :
SELECT lo_export(table.image('/tmp/outimage.jpg')
from TABLE
where TITLE ='First Picture';
I get in response 'cant open unix file system "/tmp/outimage.jpg" no such
file or directory. The problem seems to be the filename. So I tried
different filenames such as image2.jpg, etc with the same result.
I looked at the /tmp directory and I did not see any jpegs. I also looked
at the postgres/data directory to see if there is a directory labelled /tmp.
I was unsuccessful. I am using a PC running SuSE8.2.
Some help will be appreciated.
Yours sincerely
Sibu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-10-08 17:20:40 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
| Previous Message | Jonathan Bartlett | 2003-10-08 17:01:03 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |