Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0F0F29FA1DA for ; Wed, 20 Dec 2006 04:47:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 59964-09 for ; Wed, 20 Dec 2006 04:47:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.ipf.is (mack.ipf.is [85.197.192.164]) by postgresql.org (Postfix) with ESMTP id AE59B9F939F for ; Wed, 20 Dec 2006 04:47:05 -0400 (AST) Received: (qmail 22843 invoked by uid 1010); 20 Dec 2006 08:43:33 +0000 Received: from 88.149.106.19 by mack (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.4/1639. spamassassin: 3.1.4. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.4/4.5):. Processed in 0.455118 secs); 20 Dec 2006 08:43:33 -0000 X-Antivirus-HIVE-Mail-From: gnari@hive.is via mack X-Antivirus-HIVE: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.4/4.5):. Processed in 0.455118 secs Process 22831) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx1.ipf.is with SMTP; 20 Dec 2006 08:43:32 +0000 Subject: Re: Fetching BLOBs From: Ragnar To: Ashish Ahlawat Cc: pgsql-sql@postgresql.org In-Reply-To: <682126990612191925r61a3f89av93e93af3bc8e985b@mail.gmail.com> References: <682126990612191925r61a3f89av93e93af3bc8e985b@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Date: Wed, 20 Dec 2006 08:48:59 +0000 Message-Id: <1166604539.6369.264.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/153 X-Sequence-Number: 27109 On miš, 2006-12-20 at 08:55 +0530, Ashish Ahlawat wrote: > 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. > > So pls provide any simple query format for the same, assuming two > table tab1 & tab 2 a bit of friendly advice on how to ask on these lists: I you do not get any useful replies to a question, you should follow up with more details, more specific questions, show what you have tried so far, and tell us in what way that did not work. It is unlikely that repeating the same question verbatim 3 times in different threads, CC'd to some random list users will give better results than the first posting did. Remember that many of us are not native english speakers, so describe your problem as clearly and precisely as possible. For example, it is totaly unclear to me what your actual problem is. gnari