From: Kretschmer Andreas <andreas_kretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Re: Calling a table residing in another database from Plpgsql
Date: Wed, 5 Jan 2005 17:28:37 +0100
Message-ID: <20050105162837.GA6967@kaufbach.delug.de> (raw)
In-Reply-To: <43146.61.11.66.222.1104902026.squirrel@61.11.66.222>
References: <43146.61.11.66.222.1104902026.squirrel@61.11.66.222>
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° ;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas_kretschmer@despammed.com
Subject: Re: Calling a table residing in another database from Plpgsql
In-Reply-To: <20050105162837.GA6967@kaufbach.delug.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox