pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedaccessing multiple database
5+ messages / 3 participants
[nested] [flat]
* accessing multiple database
@ 2005-05-05 02:47 mohammad izwan ibrahim <izwan@orenda.com.my>
2005-05-05 06:50 ` Re: [despammed] accessing multiple database Andreas Kretschmer <akretschmer@despammed.com>
2005-05-05 06:56 ` Re: accessing multiple database Richard Huxton <dev@archonet.com>
0 siblings, 2 replies; 5+ messages in thread
From: mohammad izwan ibrahim @ 2005-05-05 02:47 UTC (permalink / raw)
To: pgsql-sql
hi all,
im finding some ideas, method, advice, n etc on accessing multiple database.The system that i'm currently develop is real time update and the data reside on few different db at different db site. Tq in advance.
Tq
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [despammed] accessing multiple database
2005-05-05 02:47 accessing multiple database mohammad izwan ibrahim <izwan@orenda.com.my>
@ 2005-05-05 06:50 ` Andreas Kretschmer <akretschmer@despammed.com>
1 sibling, 0 replies; 5+ messages in thread
From: Andreas Kretschmer @ 2005-05-05 06:50 UTC (permalink / raw)
To: pgsql-sql
am 05.05.2005, um 10:47:12 +0800 mailte mohammad izwan ibrahim folgendes:
> hi all,
>
> im finding some ideas, method, advice, n etc on accessing multiple
> database.The system that i'm currently develop is real time update and
> the data reside on few different db at different db site. Tq in
> advance.
1. write your own client thats connect to several databases
2. use dblink, this is part of the contrib-distribution
Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: accessing multiple database
2005-05-05 02:47 accessing multiple database mohammad izwan ibrahim <izwan@orenda.com.my>
@ 2005-05-05 06:56 ` Richard Huxton <dev@archonet.com>
1 sibling, 0 replies; 5+ messages in thread
From: Richard Huxton @ 2005-05-05 06:56 UTC (permalink / raw)
To: mohammad izwan ibrahim <izwan@orenda.com.my>; +Cc: pgsql-sql
mohammad izwan ibrahim wrote:
> hi all,
>
> im finding some ideas, method, advice, n etc on accessing multiple
> database.The system that i'm currently develop is real time update
> and the data reside on few different db at different db site. Tq in
> advance.
Obviously you can access more than one database from your client
software. From within PostgreSQL itself, look into the dblink package in
the contrib/ directory of the source distribution.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: accessing multiple database
@ 2005-05-05 09:09 mohammad izwan ibrahim <izwan@orenda.com.my>
2005-05-05 09:21 ` Re: accessing multiple database Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 5+ messages in thread
From: mohammad izwan ibrahim @ 2005-05-05 09:09 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; mohammad izwan ibrahim <izwan@orenda.com.my>; +Cc: pgsql-sql
Hi Richard Huxton,
Tq for your advice, Hope you can help me on this
1.can I create view from dblink query
2.can I fetch the data simultaneous from multiple database using dblink function, how the syntax would be?
tq
-- Original message --
From: "Richard Huxton" <dev@archonet.com>
To: "mohammad izwan ibrahim" <izwan@orenda.com.my>
Date: Thursday 5 May 2005 15:06:24
Subject: Re: [SQL] accessing multiple database
> mohammad izwan ibrahim wrote:
> > hi all,
> >
> > im finding some ideas, method, advice, n etc on accessing multiple
> > database.The system that i'm currently develop is real time update
> > and the data reside on few different db at different db site. Tq in
> > advance.
>
> Obviously you can access more than one database from your client
> software. From within PostgreSQL itself, look into the dblink package in
> the contrib/ directory of the source distribution.
>
> --
> Richard Huxton
> Archonet Ltd
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: accessing multiple database
2005-05-05 09:09 Re: accessing multiple database mohammad izwan ibrahim <izwan@orenda.com.my>
@ 2005-05-05 09:21 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 5+ messages in thread
From: Richard Huxton @ 2005-05-05 09:21 UTC (permalink / raw)
To: mohammad izwan ibrahim <izwan@orenda.com.my>; +Cc: pgsql-sql
mohammad izwan ibrahim wrote:
> Hi Richard Huxton, Tq for your advice, Hope you can help me on this
>
> 1.can I create view from dblink query
I believe so - see the dblink docs for details.
> 2.can I fetch the data simultaneous from multiple database using
> dblink function, how the syntax would be?
Not in one function-call, but I don't see why you couldn't have several
sub-queries, each to a different database. I recommend testing it to see.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-05-05 09:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-05 02:47 accessing multiple database mohammad izwan ibrahim <izwan@orenda.com.my>
2005-05-05 06:50 ` Andreas Kretschmer <akretschmer@despammed.com>
2005-05-05 06:56 ` Richard Huxton <dev@archonet.com>
2005-05-05 09:09 Re: accessing multiple database mohammad izwan ibrahim <izwan@orenda.com.my>
2005-05-05 09:21 ` Richard Huxton <dev@archonet.com>
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