Re: Multiple Databases - Mailing list pgsql-sql

From Joe Conway
Subject Re: Multiple Databases
Date
Msg-id 3DB6D01C.9000601@joeconway.com
Whole thread Raw
In response to Re: Multiple Databases  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Multiple Databases
Next
From: andres javier garcia garcia
Date:
Subject: odbc drivers