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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general