Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select from many database ?? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: How to select from many database ??
Date
Msg-id 20050423051943.GA96539@winnie.fuhr.org
Whole thread Raw
In response to How to select from many database ??  (Art - Feping <Feping@artindo.co.id>)
List pgsql-sql
Tree view 
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/

pgsql-sql by date:

Previous
From: "Ramakrishnan Muralidharan"
Date:
Subject: Re: SQL subquery (count distinct) - Any Ideas?
Next
From: Michael Fuhr
Date:
Subject: Re: Help to drop table