SqlHydra icon indicating copy to clipboard operation
SqlHydra copied to clipboard

Is it possible to support materialized views from Postgres?

Open Janna112358 opened this issue 6 months ago • 22 comments

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?

Janna112358 avatar Feb 19 '24 17:02 Janna112358