hi, i'd like to write sth like:

create rule MYRULE as on select to MYTABLE do instead
dblink('dbname=ANOTHERDB',querystring);

where querystring would be a special keyword, as new and old, but
containing the full query which the rule is invoked, so if i do

insert into TOTO select * from MYTABLE where ... ;

it will act as

insert into TOTO dblink('dbname=ANOTHERDB','select * from MYTABLE where
....') ;

is there any way to do such, i mean to hide the dblink, so MYTABLE is the
real MYTABLE on ANOTHERDB, but looks like a normal local table...

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings