On Wednesday 17 September 2003 18:32, Daniel Schuchardt wrote:
> Hi @ all,
>
> i'm sure there was a psql-function to transfere my Blob-Data to the
> server but I can't remember.
>
> I have a script like this :
>
> UPDATE xy SET z = lo_import('localpath_and_file');
>
> but i want to execute this script from the client and so my blob-data is
> on the client and lo_import fails (the server doesn't have this file).
> Hm.
>
> Thanks for tips - Daniel.
>
http://www.postgresql.org/docs/7.3/interactive/largeobjects.html
is what You need.
Regards !
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
