Re: opening a channel between two postgreSQL-servers?

From: Ben <bench(at)silentmedia(dot)com>
To: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: opening a channel between two postgreSQL-servers?
Date: 2006-11-05 05:11:57
Message-ID: Pine.LNX.4.64.0611042109390.8155@GRD.cube42.tai.silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I believe contrib/dblink may be what you're after...

On Sat, 4 Nov 2006, stig erikson wrote:

> Hi.
> a handy thing in mysql is FEDERATED tables that allows one to open a channel
> from one MySQL-server to another MySQL-server.
> it helps a lot when writing stored procedures that transfer data to other
> servers. you can do the transfer without
> any extarnal temporary files or external applications that read from one
> server and insert into another server.
>
> Does PG have anything similar?
> if yes, which chapter in the docs for 8.1 will tell me more?
> no wars please. i just want to know if such a possibility exists in PG.
>
> /stig
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stig erikson 2006-11-05 07:56:46 Re: opening a channel between two postgreSQL-servers?
Previous Message Tom Lane 2006-11-05 04:44:50 Re: ERROR: tuple concurrently updated