Re: connecting to a differnt DB in PL/pgSQL

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: friedrich nietzsche <nietzsche_psql(at)yahoo(dot)it>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: connecting to a differnt DB in PL/pgSQL
Date: 2003-04-14 15:45:01
Message-ID: 3E9AD77D.6020904@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-04-14 17:16:08 Re: connecting to a differnt DB in PL/pgSQL
Previous Message friedrich nietzsche 2003-04-14 15:29:03 connecting to a differnt DB in PL/pgSQL