[edmundsauto]

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]

Interestingly, DBT does not support creating materialized views.

[mritchie712]

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

[edmundsauto]

What's the effective difference between a matview and just a table?