From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | SELECT across multiple db |
Date: | 2003-05-16 14:53:04 |
Message-ID: | 1053096784.871.47.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-05-16 16:48:06 | Re: SELECT across multiple db |
Previous Message | Tom Lane | 2003-05-16 13:23:05 | Re: datestyle |