From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Union Question
Date: 3 Dec 2010 23:20:33 GMT
Message-ID: <idbu01$3qt$1@reversiblemaps.ath.cx> (raw)
References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Union Question
In-Reply-To: <idbu01$3qt$1@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox