Re: Calling a table residing in another database from Plpgsql - Mailing list pgsql-sql

deepthi@granwill.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