Union Question - Mailing list pgsql-sql

From Shaun McCloud
Subject Union Question
Date
Msg-id 7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local
Whole thread Raw
Responses Re: Union Question
List pgsql-sql
<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal">I need to union three
PostgreSQLtables and this won’t be a problem but the tables are on different servers.  Basically, I have an
administrativeserver that needs the tables viewable in a web administrator and three query servers that log the needed
datalocally.  Is there a way I can do this without using Slony-I to replicate the data to the administrative server?<p
class="MsoNormal"> <pclass="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Shaun McCloud
-Software Testing Analyst</span></b><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br
/></span></b><b><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif"">GeoComm Inc.</span></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""><br/> 601 W. Saint Germain St., Saint Cloud, MN 56301<br
/></span><b><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif"">Office:</span></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">320.240.0040 </span><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Fax:</span></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">320.240.2389 </span><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">TollFree:</span></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">888.436.2666<br /></span><b><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">clickhere to visit </span></i></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""><ahref="http://www.geo-comm.com/"><b><i><span
style="color:black;text-decoration:none">www.geo-comm.com</span></i></b></a></span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""></span><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">MicrosoftCertified Desktop Support Technician
(MCDST)</span></b><b><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif""></span></b><p
class="MsoNormal"><i><spanstyle="font-family:"Verdana","sans-serif";color:black"> </span></i><p
class="MsoNormal"><i><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif";color:black">Do or do not, there
isno try.</span></i><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:black">     -Yoda</span><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><spanstyle="font-size:12.0pt;font-family:"Times New
Roman","serif""> </span><pclass="MsoNormal"> </div> 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY with FORMAT in Postgresql 9.x
Next
From: Shaun McCloud
Date:
Subject: Re: Union Question