Re: pg 9.2.4 dblink

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Peter Kroon <plakroon(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg 9.2.4 dblink
Date: 2013-07-09 15:26:35
Message-ID: 51DC2BAB.1010308@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 07/09/2013 06:55 AM, Peter Kroon wrote:
> Hi,
>
> I want to talk to multiple db's in one session. Is dblink the best
> solution or is there another way without installing dblink?

If you want to query one database from another there is:

dblink
postgres_fdw (read only) which you can get from PGXN

Sincerely,

JOshua D. Drake

--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps of my heart. - W.B. Yeats

In response to

Browse pgsql-general by date

  From Date Subject
Next Message giozh 2013-07-09 16:30:35 function with unknown params
Previous Message Adrian Klaver 2013-07-09 14:37:06 Re: domains, case statements, functions: bug?