Обсуждение: Multiple Databases
Is it possible to create a view using tables from two different postgresql servers? Thanks Peter
Peter, > Is it possible to create a view using tables from two different > postgresql > servers? No. -Josh Berkus
Josh Berkus wrote: >>Is it possible to create a view using tables from two different >>postgresql >>servers? > > No. > It isn't possible with plain old SQL, but it is possible (albeit ugly) using contrib/dblink in PostgreSQL 7.2.x. See README.dblink for documentation and examples. In PostgreSQL 7.3 (in beta testing now) the syntax and usability of contrib/dblink is greatly improved. Joe
thanks for your help guys. Peter "Joe Conway" <mail@joeconway.com> wrote in message news:3DB6D01C.9000601@joeconway.com... > Josh Berkus wrote: > >>Is it possible to create a view using tables from two different > >>postgresql > >>servers? > > > > No. > > > > It isn't possible with plain old SQL, but it is possible (albeit ugly) using > contrib/dblink in PostgreSQL 7.2.x. See README.dblink for documentation and > examples. > > In PostgreSQL 7.3 (in beta testing now) the syntax and usability of > contrib/dblink is greatly improved. > > Joe > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org