Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group