Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0A489476135
	for <pgsql-sql@postgresql.org>; Wed, 23 Oct 2002 12:38:10 -0400 (EDT)
Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 65F72475FEE
	for <pgsql-sql@postgresql.org>; Wed, 23 Oct 2002 12:38:09 -0400 (EDT)
Received: from [206.19.64.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.9)
	with ESMTP-TLS id 1364783; Wed, 23 Oct 2002 09:07:35 -0700
Message-ID: <3DB6D01C.9000601@joeconway.com>
Date: Wed, 23 Oct 2002 09:36:44 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: peter <peter@peter.com>, pgsql-sql@postgresql.org
Subject: Re: Multiple Databases
References: <web-1796548@davinci.ethosmedia.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/303
X-Sequence-Number: 10020

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