| From: | Kretschmer Andreas <andreas_kretschmer(at)despammed(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Calling a table residing in another database from Plpgsql |
| Date: | 2005-01-05 16:28:37 |
| Message-ID: | 20050105162837.GA6967@kaufbach.delug.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
am Tue, dem 04.01.2005, um 21:13:46 -0800 mailte deepthi(at)granwill(dot)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° ;-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | drdani | 2005-01-05 19:45:21 | plpsql function problem |
| Previous Message | Kris Jurka | 2005-01-05 15:37:42 | Re: Calling a table in another database from plpgsql |