frlan
Reputation: 7270
Materialized view on a foreign table with postgresql_fdw
Is it possible to use a materialized view on top of a foreign table with postgresql_fdw? (Postgres 9.3)
Currently thinking of some kind of "caching" for postgresql_fdw.
Upvotes: 2
Views: 1551
Answers (1)
frlan
Reputation: 7270
View can be updated by REFRESH MATERIALIZED VIEW. No real need for external triggering.
Upvotes: 1
Related Questions
- Calling a materialized view from another materialized view in Postgres
- How to get materialized views that refer to a table in postgresql
- Create a foreign table pointing to a view in Postgres
- ERROR: must be owner of materialized view PostgreSQL
- How to alter materialized view with dependent views
- Postgresql - create materialized view
- pgsql Materialized view refresh
- Oracle foreign data wrapper
- Materialized view not working as expected?
- Adapt materialized view from oracle db to postgres