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