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