Re: connecting to a differnt DB in PL/pgSQL

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