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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to