Any plans to support materialized views?

[eboswort]

Would that be very difficult or not work for some reason?

[ronen]

No specific plans, but I'm not opposed to it.

It should be straightforward to implement, just a matter of figuring out a good API for it (e.g., create via options to create_view or a newcreate_materialized view call? What about refreshing?). And it'd all be specific to postgresql, so would need to decide whether it should go here or in a separate "schema_plus_pg_views" gem.

I don't have time to work on it myself, but I'm open to a PR if somebody wants to think it through and put it together.

[eboswort]

Ok cool. Well it's possible I'll find time to take a crack at this but it probably wouldn't be for a while.

[ronen]

Ok. If you do take a crack at it, feel free to give me a shout if you have any questions or run into snags.

[ronen]

BTW, see earlier start and discussion at SchemaPlus/schema_plus#154