Re: [SQL] Multiple Databases

[Joe Conway]

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