[Sqlalchemy-tickets] Issue #3588: Extend view reflection in PostgreSQL to support differentiating between normal views and materialized views (zzzeek/sqlalchemy)

[Jeff W. <iss...@bi...>]

New issue 3588: Extend view reflection in PostgreSQL to support differentiating between normal views and materialized views
https://bitbucket.org/zzzeek/sqlalchemy/issues/3588/extend-view-reflection-in-postgresql-to

Jeff Widman:

I'm trying to write a simple python function that refreshes all the materialized views in a PostgreSQL db.

Ideally the core would include a 'refresh_all()' that does this automagically, but it gets complicated quickly because some views might depend on other views. So instead I'd like for sqlalchemy to support querying the db to get a list of all the materialized view names

#2891 nicely added support for PostgreSQL materialized views in inspect.get_view_names()

However, it's not possible to limit the query to only normal views or only materialized views. 

Nor does the list of returned view names include anything about whether they're normal views vs materialized views... That'd probably be simpler--just return all view names, but also include what type of view it is.