Remote connections?

I just found out something about Oracle which that looks like something
that could be doable in PostgreSQL.

What do you all think:

Oracle's version is something like this:

create [public] database link using [...]

select * from sometable(at)remotelink

I was thinking how this could be done with postgreSQL. How hard would it
be to make something that is similar to a view, but executes a query
remotely? I envision something like this:

create [public] link name query using [...]

The table link will be similar to a view. It could be used like this:

CREATE LINK test as select * from test WITH 'user=postgres host=remote
db=data';

SELECT * from test;

or

SELECT * from fubar join test on (fubar.id = test.id) ;

So, what do you think? Impossible, possible, too hard? too easy?