pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFetching BLOBs
3+ messages / 3 participants
[nested] [flat]
* Fetching BLOBs
@ 2006-12-20 03:25 Ashish Ahlawat <ahlawat.ashish@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Ashish Ahlawat @ 2006-12-20 03:25 UTC (permalink / raw)
To: Ragnar <gnari@hive.is>; +Cc: Dirk Griffioen <dirk@code-shop.com>; pgsql-sql
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.
So pls provide any simple query format for the same, assuming two table tab1
& tab 2.
Ashish ............. INDIA
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fetching BLOBs
@ 2006-12-20 06:59 Richard Huxton <dev@archonet.com>
parent: Ashish Ahlawat <ahlawat.ashish@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2006-12-20 06:59 UTC (permalink / raw)
To: Ashish Ahlawat <ahlawat.ashish@gmail.com>; +Cc: Ragnar <gnari@hive.is>; Dirk Griffioen <dirk@code-shop.com>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fetching BLOBs
@ 2006-12-20 08:48 Ragnar <gnari@hive.is>
parent: Ashish Ahlawat <ahlawat.ashish@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ragnar @ 2006-12-20 08:48 UTC (permalink / raw)
To: Ashish Ahlawat <ahlawat.ashish@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-12-20 08:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-20 03:25 Fetching BLOBs Ashish Ahlawat <ahlawat.ashish@gmail.com>
2006-12-20 06:59 ` Richard Huxton <dev@archonet.com>
2006-12-20 08:48 ` Ragnar <gnari@hive.is>
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