From: Richard Huxton <dev@archonet.com>
To: Ashish Ahlawat <ahlawat.ashish@gmail.com>
Cc: Ragnar <gnari@hive.is>
Cc: Dirk Griffioen <dirk@code-shop.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Fetching BLOBs
Date: Wed, 20 Dec 2006 06:59:25 +0000
Message-ID: <4588DF4D.7000704@archonet.com> (raw)
In-Reply-To: <682126990612191925r61a3f89av93e93af3bc8e985b@mail.gmail.com>
References: <682126990612191925r61a3f89av93e93af3bc8e985b@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ahlawat.ashish@gmail.com, gnari@hive.is, dirk@code-shop.com
Subject: Re: Fetching BLOBs
In-Reply-To: <4588DF4D.7000704@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox