From: Michael Fuhr <mike@fuhr.org>
To: Art - Feping <Feping@artindo.co.id>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: How to select from many database ??
Date: Fri, 22 Apr 2005 23:19:43 -0600
Message-ID: <20050423051943.GA96539@winnie.fuhr.org> (raw)
In-Reply-To: <329EE23F2E3C9843B969AE66CDCB69C902C632@hmu>
References: <329EE23F2E3C9843B969AE66CDCB69C902C632@hmu>
On Tue, Apr 19, 2005 at 10:13:52AM +0700, Art - Feping wrote:
>
> i want to select from many databases, for example , i want to select table
> master in database A, and table master in database B.
> can i do it like this : " select * from A.Master, B.Master " just like
> in SQL Server ??
PostgreSQL doesn't directly support queries to multiple databases,
but see contrib/dblink for a way to do it. See also the third-party
dbi-link module.
http://pgfoundry.org/projects/dbi-link
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
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: mike@fuhr.org, Feping@artindo.co.id
Subject: Re: How to select from many database ??
In-Reply-To: <20050423051943.GA96539@winnie.fuhr.org>
* 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