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...When is > this functionality expected to be available in PostgreSQL? I as well as many others > want to be able to run queries such as > > SELECT a.field_a, b.field_b FROM user:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
