Re: Union Question - Mailing list pgsql-sql

From Jasen Betts
Subject Re: Union Question
Date
Msg-id idbu01$3qt$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Union Question  (Shaun McCloud <smccloud@geo-comm.com>)
List pgsql-sql
On 2010-12-03, Shaun McCloud <smccloud@geo-comm.com> wrote:
> --_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Hello,
>
> I need to union three PostgreSQL tables and this won't be a problem but the=
>  tables are on different servers.  Basically, I have an administrative serv=
> er that needs the tables viewable in a web administrator and three query se=
> rvers that log the needed data locally.  Is there a way I can do this witho=
> ut using Slony-I to replicate the data to the administrative server?

modify the web adminsitrator to connect to the three servers and do the
union itself.

-- 
⚂⚃ 100% natural


pgsql-sql by date:

Previous
From: Michał Roszka
Date:
Subject: A note on how to generate a list of months within some period of time.
Next
From: Mario Splivalo
Date:
Subject: Re: Get the max viewd product_id for user_id