Josh Berkus wrote:
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.Is it possible to create a view using tables from two different postgresql servers?No.
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