Re: SELECT across multiple db

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SELECT across multiple db
Date: 2003-05-16 18:41:02
Message-ID: 1053110462.667.9.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Am Fre, 2003-05-16 um 18.48 schrieb Joe Conway:
> Nabil Sayegh wrote:
> > http://candle.pha.pa.us/mhonarc/todo.detail/crossdb/msg00000.html
> > It's about 'Remote connections'. (see bottom)
>
> See contrib/dblink

Thanks for your answer.
It's not exactly what I was looking for, because I wanted to do 1 query
across many databases and the results put together and sorted etc.

But with the keyword 'dblink' and google I found out that what I really
wanted is: SCHEMA :)

But it seems that this needs 7.3 which is not in debian testing (sarge)
because of perl dependencie problems :(
It's in unstable (sid) but I can't install sid on a production system.

However, thanks all and kudos to the PostgreSQL developers for your
great work.

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-16 18:50:07 Re: datestyle
Previous Message Juliet May 2003-05-16 17:56:08 Re: Query regarding Insert Statement!!!!