PostgreSQL Accessing multiple database from stored function

Question

I want to access different databases from postgresql stored functions.

For example:

CREATE OR REPLACE FUNCTION test ()  RETURNS SETOF volume AS
$BODY$

SELECT * FROM db2.volume
ORDER BY db2.volume.volumeID

$BODY$  
LANGUAGE sql STABLE  
COST 100  
ROWS 1000;

any input will be great help.

Regards, Manasi

Answer 1

what you need is database link