X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 005D63A3D22
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  5 Jan 2005 12:51:24 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 75523-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  5 Jan 2005 12:51:00 +0000 (GMT)
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 357A93A41AF
	for <pgsql-sql@postgresql.org>; Wed,  5 Jan 2005 12:51:02 +0000 (GMT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 317DE313EA; Wed,  5 Jan 2005 13:51:03 +0100 (MET)
From: CoL <col@mportal.hu>
X-Newsgroups: pgsql.sql
Subject: Re: Calling a table residing in another database from Plpgsql
Date: Wed, 05 Jan 2005 13:50:42 +0100
Organization: Hub.Org Networking Services
Lines: 20
Message-ID: <crgnrh$2a7i$1@news.hub.org>
References: <43146.61.11.66.222.1104902026.squirrel@61.11.66.222>
Reply-To: col@mportal.hu
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.8a5) Gecko/20041122
X-Accept-Language: en-us, en
In-Reply-To: <43146.61.11.66.222.1104902026.squirrel@61.11.66.222>
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200501/28
X-Sequence-Number: 19816

hi,

deepthi@granwill.com 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 an error as "ERROR:  function dblink("unknown", "unknown")
> does not exist"

try to set up dblink. Read the README.dblink file, Installation: part.
Use dblink_connect to connect, then you can query with dblink()

read the docs befor you try to use it.

PS: or better use schemas, not different databases.

C.