[GENERAL] help with large objects in 7.3.4
Greetings, I am trying to create a database to store imges as large objects. I am using postgres7.3.4 on a SuSE8.2 machine. I read the PostgreSQL documentation on lage objects. There are some new fnctions which I am unfamilar with. I have books on postgresql but I am not aware of any current book with example usage of these functions. I previously used up to 7.2 which had lo_import, lo_export and lo_unlink. I would be grateful for example usage in psql of the following functions (seen in postgresql7.3.4: lo_create, lo_import lo_export lo_import lo_open lo_write lo_read lo_seek Help would be appreciated. Yours sincerely Sibu ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] problems retrieving images in 7.3.4
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
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
