Shigeru Hanada <shigeru.hanada@gmail.com> writes:
> I'm sorry but I don't see the point here. Do you mean that user
> executes CREATE FOREIGN VIEW in advance and uses the view in a
Yes that's what I mean.
> I think it's nice to support executing ad-hoc remote query written in
> the syntax which is valid only on remote data source through FDW, and
> at the moment dblink interface seems feasible for that purpose.
I guess the view query would have to be validated by the FDW, which
would just receive a text.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support