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...