物化视图不在pg_view中,在pg_matviews中。
查询语句:
select schemaname as schema_name,
matviewname as view_name,
matviewowner as owner,
ispopulated as is_populated,
definition
from pg_matviews
order by schema_name,
view_name;
postgresql如何查询物化视图脚本内容
于 2022-02-11 17:34:40 首次发布