From: mohammad izwan ibrahim <izwan@orenda.com.my>
To: Richard Huxton <dev@archonet.com>
To: mohammad izwan ibrahim <izwan@orenda.com.my>
Cc: pgsql-sql@postgresql.org
Subject: Re: accessing multiple database
Date: Thu, 05 May 2005 17:09:22 +0800
Message-ID: <200505050909.j4599Ml4023684@smp.orenda.com.my> (raw)
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
>
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: izwan@orenda.com.my, dev@archonet.com
Subject: Re: accessing multiple database
In-Reply-To: <200505050909.j4599Ml4023684@smp.orenda.com.my>
* 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