Re: connecting to a differnt DB in PL/pgSQL - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: connecting to a differnt DB in PL/pgSQL
Date
Msg-id 3E9AD77D.6020904@klaster.net
Whole thread Raw
In response to connecting to a differnt DB in PL/pgSQL  (friedrich nietzsche <nietzsche_psql@yahoo.it>)
Responses Re: connecting to a differnt DB in PL/pgSQL  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
List 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



pgsql-sql by date:

Previous
From: friedrich nietzsche
Date:
Subject: connecting to a differnt DB in PL/pgSQL
Next
From: Radovan Petrikí
Date:
Subject: REPLACE