Postgres Pro
Downloads
Home   >   mailing lists

Thread: Foreign Data Wrapper for remote view?

Foreign Data Wrapper for remote view?

From
Deven Phillips
Date:
To prevent multiple foreign table scans during queries, I would like to be able to create an FDW against a VIEW in a foreign MySQL database. Is this possible?

Thanks in advance!

Deven

Re: Foreign Data Wrapper for remote view?

From
Deven Phillips
Date:
Nevermind, it works exactly as I would have expected and it is the exact speed improvement I needed!

Deven

On Mon, Mar 30, 2015 at 10:12 AM, Deven Phillips <deven.phillips@gmail.com> wrote:
To prevent multiple foreign table scans during queries, I would like to be able to create an FDW against a VIEW in a foreign MySQL database. Is this possible?

Thanks in advance!

Deven