dblink and REWRITE - Mailing list pgsql-general

From Darko Prenosil
Subject dblink and REWRITE
Date
Msg-id 025d01c1d10a$723441b0$f600000a@darko
Whole thread Raw
List pgsql-general
We have a request from our customers to link two database servers through the ISDN link.
 
    Few days ago we wrote a function than can execute the query on the host server, send the
result to the remote server and store it in a temp table. All working fine, but now I'm trying to make
things transparent for the users. One of the first requests was to create a view that represents
the remote data table.
 
Is it possible to do next using rewrite rule:
Execute function with parameters ,get only needed rows from remote and then return data from created temp table as view data ?
 
And if we suceed we can say that we have remote parameterized view !!!
 
Best Regards !
 
Darko

pgsql-general by date:

Previous
From: "daniel"
Date:
Subject: Re: Newbie question - Which Linux?
Next
From: Dmitry Tkach
Date:
Subject: A general database question!