dbLink Query - Mailing list pgsql-sql

From Richard C
Subject dbLink Query
Date
Msg-id 20060224112916.7385.qmail@web25211.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: dbLink Query
List pgsql-sql
Hi
 
When I execute the query:
 
SELECT *
FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
WHERE t.id > 9000 AND T.ID < 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


To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.

pgsql-sql by date:

Previous
From: "Daniel Joo"
Date:
Subject: how to add primary key to existing table with multiple primary keys
Next
From: "Bungsuputra Linan"
Date:
Subject: Re: Slow update SQL