| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Ashish Ahlawat <ahlawat(dot)ashish(at)gmail(dot)com> |
| Cc: | Ragnar <gnari(at)hive(dot)is>, Dirk Griffioen <dirk(at)code-shop(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Fetching BLOBs |
| Date: | 2006-12-20 06:59:25 |
| Message-ID: | 4588DF4D.7000704@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ragnar | 2006-12-20 08:48:59 | Re: Fetching BLOBs |
| Previous Message | Ashish Ahlawat | 2006-12-20 03:25:58 | Fetching BLOBs |