How to make lo_import and lo_export to use file on client local machine?

Started by Premsun Choltanwanichover 21 years ago2 messagesgeneral
Jump to latest
#1Premsun Choltanwanich
Premsun@nsasia.co.th

I try to use lo_import and lo_export for manage large object on
PostgreSQL. I found that all files must be process on server with these
commands.

Could I make lo_import and lo_export to use file on client local
machine?
And How?

Or Is it has other ways to manage large object that process is between
client local machine and PostgreSQL database?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Premsun Choltanwanich (#1)
Re: How to make lo_import and lo_export to use file on client local machine?

"Premsun Choltanwanich" <Premsun@nsasia.co.th> writes:

Could I make lo_import and lo_export to use file on client local
machine?

If you're using libpq, it has lo_export and lo_import functions.
If you're using some other client-side code, see its documentation.

regards, tom lane