Re: [SQL] Calling a table residing in another database from Plpgsql

2005-01-09 Thread CoL
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

Re: [SQL] Calling a table residing in another database from Plpgsql

2005-01-05 Thread Joe Conway
[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

Re: [SQL] Calling a table residing in another database from Plpgsql

2005-01-05 Thread Kretschmer Andreas
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

Re: [SQL] Calling a table residing in another database from Plpgsql

2005-01-04 Thread Kenneth Gonsalves
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)

[SQL] Calling a table residing in another database from Plpgsql

2005-01-04 Thread deepthi
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