thanks for your help guys. Peter
"Joe Conway" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html