"Installing" dbLink - Mailing list pgsql-sql

From Richard C
Subject "Installing" dbLink
Date
Msg-id 20060224114844.29958.qmail@web25224.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: "Installing" dbLink
List pgsql-sql
Hi
 
When I execute the query:
 
SELECT *
FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
WHERE t.a > 9000 AND T.a < 9050;
 
I receive the error message
 
ERROR:  function dblink("unknown", "unknown") does not exist
 
How do I install or setup the function dbLink so that I can use this feature.
 
Regards
Richard


Win a BlackBerry device from O2 with Yahoo!. Enter now.

pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: CREATE TABLE AS and tablespaces
Next
From: "A. Kretschmer"
Date:
Subject: Re: "Installing" dbLink