On Oct 26, 2006, at 2:07 PM, Douglas Anderson wrote:
Anyone done any work with BLOBS in a PostgreSQL database? I've got
things running using the lo_import and lo_export but would rather
simply
write binary data to the database and then retrieve later without
having
to have the file on the database server as the client app will be run
from another system and having the data write on the host db system is
somewhat useless to me. There is a lo_export and lo_import set of SQL
commands but I'm not sure I understand how to use them and having a
hard
time with some of the documentation/references on the web. If anyone
has a code snippet or two they can share that would be much
appreciated.
convert your blob to a string and insert it
retrieval is the reverse
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
