From: Tomasz Myrta <jasiek@klaster.net>
To: friedrich nietzsche <nietzsche_psql@yahoo.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: connecting to a differnt DB in PL/pgSQL
Date: Mon, 14 Apr 2003 17:45:01 +0200
Message-ID: <3E9AD77D.6020904@klaster.net> (raw)
In-Reply-To: <20030414152903.32560.qmail@web40502.mail.yahoo.com>
References: <20030414152903.32560.qmail@web40502.mail.yahoo.com>
Uz.ytkownik friedrich nietzsche napisa?:
> Hi all,
> Is it possible to connect to another database within a
> PL/PgSQL function?
>
> I'm in a function on the "A" database and I need to
> retrieve some information from a table in a different
> Database "B"
>
> may someone help me?
>
> thanks, Danilo.
> bye.
You can't access another database even inside 1 server directly.
Find something about contrib/dblink - maybe it will help you.
Regards,
Tomasz Myrta
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net, nietzsche_psql@yahoo.it
Subject: Re: connecting to a differnt DB in PL/pgSQL
In-Reply-To: <3E9AD77D.6020904@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox