Add support for Materialized Views

stripe / pg-schema-diff

Go library for diffing Postgres schemas and generating SQL migrations

MIT License

346 stars 25 forks source link

Add support for Materialized Views #173

Open jayadevanm opened 3 weeks ago

jayadevanm commented 3 weeks ago

The documentation does mention that Views are not supported. It looks like Materialized Views are also not supported, though they are more like tables than views. We can create indexes, they contain data etc.

bplunkett-stripe commented 2 weeks ago

It's unfortunately not the straight forward (think webs of dependencies), but I do intend to add support for them and have a mental model in my head as to how I will achieve it. I first would like to refactor the SQL generation a bit before I implement (materialized) views.