Re: Fetching BLOBs - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Fetching BLOBs
Date
Msg-id 4588DF4D.7000704@archonet.com
Whole thread Raw
In response to Fetching BLOBs  ("Ashish Ahlawat" <ahlawat.ashish@gmail.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Ashish Ahlawat"
Date:
Subject: Fetching BLOBs
Next
From: Ragnar
Date:
Subject: Re: Fetching BLOBs