Blob stuff
От
Patrick Nelson
Тема
Blob stuff
Дата
Msg-id
4165C48DE9A0D211B6400800095C585F172E0E@WASHINGTON
Список
Дерево обсуждения
Re: Blob stuff Patrick Nelson <pnelson@neatech.com>
Re: Blob stuff Tom Lane <tgl@sss.pgh.pa.us>
OK maybe I'm cutting new ground and no one has or knows how to utilize blob
data.
On a remote client the proper way to insert a blob into the table is:
1. copy myblob.gif (through ftp or scp) to the server to a predefined
directory
2. use INSERT INTO mytable VALUES (lo_import('/myblob.gif'));
3. use SELECT lo_export(mycol, '/myblob.gif') FROM mytable WHERE
;
4. To unlink use SELECT lo_unlink(mycol) FROM mytable WHERE ;
5. copy myblob.gif (through ftp or scp) from the server back to the remote
cliet
Any comments?
There is \lo_import, \lo_export, \lo_list, and \lo_unlink which seem to
utilize a remote client to upload, but this isn't a great solution if your
not using psql. Even if you do use psql, I'm not sure how to include the
lo_ into a db solution. Any comments?
В списке pgsql-general по дате отправления
От: strange@nsk.yi.org
Дата: