SqlHydra
SqlHydra copied to clipboard
Is it possible to support materialized views from Postgres?
Hi!
We're using a Postgres database with some views to read from. I would like to make them materialized views instead for performance reasons (the underlying data isn't updated very often). It seems that sqlhydra.cli doesn't generate any types for newly added materialized views. I also tried removing an existing view and adding a materialized view with the same name and columns in the db, and using the already generated types file, but that resulted in runtime errors in the sqhlyra.query code.
Is support for materialized views wanted and is it even possible?