You can use the 'dblink' contrib module for that purpose...
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Robert Rak <robertrak81(at)tlen(dot)pl> wrote:
>
> Hi all :)
>
> Is it possible to fetch data from another database than the current?
>
> I have stored procedure in DB_1 and I would like do INSERT to table in
> DB_2. Is it possible?
> If yes, ho to do it?
>
> Thanks
> Robert
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>