Re: question about selecting across multiple dbs - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: question about selecting across multiple dbs
Date
Msg-id 1078766301.57624.93.camel@jester
Whole thread Raw
In response to question about selecting across multiple dbs  (Joe Maldonado <jmaldonado@webehosting.biz>)
Responses Re: question about selecting across multiple dbs
Re: question about selecting across multiple dbs
List pgsql-hackers
On Mon, 2004-03-08 at 11:57, Joe Maldonado wrote:
> Hello,
>     I see that there is an item "Queries across databases or servers (two-phase commit)" on the todo list's urgent
header.I have tried asking this question on the other lists and have not yet gotten a suitable answer to this
question...Whenis this functionality expected to be available in PostgreSQL?  I as well as many others want to be able
torun queries such as
 
> 
> SELECT a.field_a, b.field_b FROM user:pwd@host.database.schema.table_a AS a NATURAL JOIN local_table AS b;

Cross database selects can be accomplished using contrib/dblink.

It will be some time before cross database writes or locks will be
possible.




pgsql-hackers by date:

Previous
From: Flavio
Date:
Subject: Data from Binary Cursor
Next
From: Josh Berkus
Date:
Subject: Re: raising the default default_statistics_target