SELECT across multiple db

Hi all,

AFAIR this is not possible in standard SQL, but then I found this topic
linked from 'PostgreSQL Todo List':

http://candle.pha.pa.us/mhonarc/todo.detail/crossdb/msg00000.html
It's about 'Remote connections'. (see bottom)

Unfortunately I need such a feature now for some of my customers.
They have multiple similar Websites (and similar db).
Now they want a meta site that takes parts of the different sites ...

Of course I could open connections to all databases and handle each db
seperately, but in order to GROUP, SORT, UNION etc, it would be much
much much more handy do have such a crossdb feature.

As the post was from Dec 2001, perhaps it's already implemented ?
(Read Acess would be enough, no need for transactions)


----------------------------------
> > The table link will be similar to a view. It could be used like
this:
> >
> > CREATE LINK test as select * from test WITH 'user=postgres host=remote
> > db=data';
> >
> > SELECT * from test;
> >
> > or
> >
> > SELECT * from fubar join test on (fubar.id = test.id) ;
----------------------------------


--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de