Re: Union Question

I'm trying that, but I am getting an error that says "ERROR: function dblink_connect(unknown, unknown) does not exist"

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

From: Plugge, Joe R. [mailto:JRPlugge(at)west(dot)com]
Sent: Friday, December 03, 2010 10:58
To: Shaun McCloud; pgsql-sql(at)postgresql(dot)org
Subject: RE: Union Question

You may want to try dblink.

http://www.postgresql.org/docs/current/static/dblink.html

From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Shaun McCloud
Sent: Friday, December 03, 2010 10:51 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Union Question

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