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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
