Re: question about selecting across multiple dbs

On Mon, 08 Mar 2004 12:18:22 -0500, Rod Taylor <pg@rbt.ca> wrote:

> 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.
>

THANKS!!!! this looks very promising and it seems that there are function available for insert/update/delete.

Again thanks

-Joe



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/