Re: How to select from many database ??

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Art - Feping <Feping(at)artindo(dot)co(dot)id>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to select from many database ??
Date: 2005-04-23 05:19:43
Message-ID: 20050423051943.GA96539@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-04-23 05:26:44 Re: Help to drop table
Previous Message Michael Fuhr 2005-04-22 20:36:30 Re: C function - other process