Обсуждение: pg 9.2.4 dblink

On Tue, Jul 09, 2013 at 03:55:47PM +0200, Peter Kroon wrote:

> I want to talk to multiple db's in one session.

You'll have to define "session" to get meaningful answers.

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

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

On Tue, Jul 9, 2013 at 8:55 AM, Peter Kroon <plakroon@gmail.com> 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?

why not use dblink?   fdw is getting there but I still find dblink to
be the way to go as long as it's postgres to postgres.

merlin