3 ms·

I also wish this were in core posgres, but if you use a build tool like DBT you can enable this type of thing.

• snicker7 4y ago
  Interestingly, DBT does not support creating materialized views.
  • mritchie712 4y ago
    yeah, this issue has been open for years. We need them for Clickhouse for our product. https://github.com/dbt-labs/dbt-core/issues/1162 https://github.com/dbt-labs/dbt-core/issues/1162
  • edmundsauto 4y ago
    What's the effective difference between a matview and just a table?