Re: Multiple Databases

From: Joe Conway <mail(at)joeconway(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: peter <peter(at)peter(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Multiple Databases
Date: 2002-10-23 16:36:44
Message-ID: 3DB6D01C.9000601@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message andres javier garcia garcia 2002-10-23 16:53:40 odbc drivers
Previous Message Josh Berkus 2002-10-23 16:31:58 Re: Multiple Databases