Re: Calling a table residing in another database from Plpgsql

From: Joe Conway <mail(at)joeconway(dot)com>
To: deepthi(at)granwill(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Calling a table residing in another database from Plpgsql
Date: 2005-01-05 14:54:08
Message-ID: 41DBFF90.7000202@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

deepthi(at)granwill(dot)com 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
README.dblink.

Joe

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kris Jurka 2005-01-05 15:37:42 Re: Calling a table in another database from plpgsql
Previous Message Dave Cramer 2005-01-05 13:48:15 Re: Calling a table in another database from plpgsql