From: | f g <fg0fg1(at)yahoo(dot)fr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | dblink + rule on select |
Date: | 2006-03-04 17:30:17 |
Message-ID: | 20060304173017.27683.qmail@web26108.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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...
___________________________________________________________________________
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Zouari Fourat | 2006-03-04 22:26:19 | encoding problem |
Previous Message | f.g | 2006-03-04 17:26:21 | dblink + rule on select |