On Fri, Dec 3, 2010 at 8:58 AM, Plugge, Joe R. 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
> se
On 2010-12-03, Shaun McCloud wrote:
> --_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Hello,
>
> I need to union three PostgreSQL tables and this won't be a problem but the=
> tables a
(MCDST)
Do or do not, there is no try.
-Yoda
-Original Message-
From: Christophe Pettus [mailto:x...@thebuild.com]
Sent: Friday, December 03, 2010 11:27
To: Shaun McCloud
Cc: Plugge, Joe R.; pgsql-sql@postgresql.org
Subject: Re: [SQL] Union Question
On Dec 3, 2010, at 9:08 AM
On Dec 3, 2010, at 9:08 AM, Shaun McCloud wrote:
> That would be nice to see in the documentation for dblink
It's true of all contrib modules; that's mentioned at the start of the contrib
section:
http://www.postgresql.org/docs/9.0/interactive/contrib.html
--
-- Christophe Pettus
x.
Technician (MCDST)
Do or do not, there is no try.
-Yoda
-Original Message-
From: Christophe Pettus [mailto:x...@thebuild.com]
Sent: Friday, December 03, 2010 11:08
To: Shaun McCloud
Cc: Plugge, Joe R.; pgsql-sql@postgresql.org
Subject: Re: [SQL] Union Question
On Dec 3, 2010, at
On Dec 3, 2010, at 9:04 AM, Shaun McCloud wrote:
> I’m trying that, but I am getting an error that says “ERROR: function
> dblink_connect(unknown, unknown) does not exist”
dblink is a contrib module, and needs to be installed before use:
http://www.postgresql.org/docs/9.0/interactive/
You may want to try dblink.
http://www.postgresql.org/docs/current/static/dblink.html
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Shaun McCloud
Sent: Friday, December 03, 2010 10:51 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Union Question
resql.org
Subject: RE: Union Question
You may want to try dblink.
http://www.postgresql.org/docs/current/static/dblink.html
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Shaun McCloud
Sent: Friday, December 03, 2010 10:51 AM
To: pgsql-sql@postgresql.org
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 d