Union Question

From: Shaun McCloud <smccloud(at)geo-comm(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Union Question
Date: 2010-12-03 16:51:02
Message-ID: 7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Shaun McCloud - Software Testing Analyst
GeoComm Inc.
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666
click here to visit www.geo-comm.com<http://www.geo-comm.com/>
Microsoft Certified Desktop Support Technician (MCDST)

Do or do not, there is no try.
-Yoda

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Plugge, Joe R. 2010-12-03 16:58:23 Re: Union Question
Previous Message Tom Lane 2010-12-03 15:51:50 Re: COPY with FORMAT in Postgresql 9.x