hi,
[EMAIL PROTECTED] wrote, On 1/5/2005 06:13:
I infact downloaded the dblink package in contrib folder. But still when i
tried to use dblink in the following manner:
SELECT * from dblink('host=192.168.0.50 dbname=AK1 user=akteam','Select
userid from user_reg') as t (userid integer);
I am getting
[EMAIL PROTECTED] wrote:
SELECT * from dblink('host=192.168.0.50 dbname=AK1 user=akteam','Select
userid from user_reg') as t (userid integer);
I am getting an error as "ERROR: function dblink("unknown", "unknown")
does not exist"
Have you installed the dblink functions into your database? See
REA
am Tue, dem 04.01.2005, um 21:13:46 -0800 mailte [EMAIL PROTECTED] 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 documenta
On Wednesday 05 January 2005 10:43 am, [EMAIL PROTECTED] wrote:
> 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.
shouldnt you be using schemas instead?
kg
---(end of broadcast)
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 pack