Re: Calling a table residing in another database from Plpgsql - Mailing list pgsql-sql

From Kretschmer Andreas
Subject Re: Calling a table residing in another database from Plpgsql
Date
Msg-id 20050105162837.GA6967@kaufbach.delug.de
Whole thread Raw
In response to Calling a table residing in another database from Plpgsql  (deepthi@granwill.com)
List pgsql-sql
am  Tue, dem 04.01.2005, um 21:13:46 -0800 mailte deepthi@granwill.com folgendes:
> Hi,
> 
> I have function called test1() in database 1. I need to input the value
> from this function into another table which is in database2.
> 
> How can i achieve this task in plpgsql. I went through some documentation
> and found out that it is possible through dblink.
> 
> I infact downloaded the dblink package in contrib folder. But still when i
> tried to use dblink in the following manner:

You must run the dblink.sql, not only download.


Regards, Andreas
-- 
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)


pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Calling a table residing in another database from Plpgsql
Next
From: drdani@mazsola.iit.uni-miskolc.hu
Date:
Subject: plpsql function problem