Re: Union Question - Mailing list pgsql-sql

From bricklen
Subject Re: Union Question
Date
Msg-id AANLkTinidsyFGG8hwB+KGaGu5MMZWKRaia8R-w7MQPMs@mail.gmail.com
Whole thread Raw
In response to Re: Union Question  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-sql
On Fri, Dec 3, 2010 at 8:58 AM, Plugge, Joe R. <JRPlugge@west.com> wrote:
> 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 server
> that needs the tables viewable in a web administrator and three query
> servers that log the needed data locally.  Is there a way I can do this
> without using Slony-I to replicate the data to the administrative server?

PL/Proxy might fit the bill also.

http://pgfoundry.org/projects/plproxy/
http://wiki.postgresql.org/wiki/PL/Proxy


pgsql-sql by date:

Previous
From: mike@if-then-else.pl
Date:
Subject: Re: The best option to insert data with primary id
Next
From: Tony Capobianco
Date:
Subject: concatenate question