Re: Fetching BLOBs

Ashish Ahlawat wrote:
> Hi team
> 
> I have a very intersting question to all of you. Pls help me to build this
> query, I want to fetch more that 70,000 BLOB from different customer
> servers. the issue is there are some BOLB files with common names on all
> servers. So I want merge these files into a single BLOB during  fetching
> data. I am able to fetch the  BLOB data from all cust servers but
> unfortunatelly it overwrite previous file.

The lo_export() function makes you supply the filename, so you can name 
the destination file however you like. I must be misunderstanding you - 
can you provide an example of what you're doing at the moment?

--   Richard Huxton  Archonet Ltd