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/