On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:
> Unless I'm completely mistaken, the second code example on
> https://www.postgresql.org/docs/current/rules-materializedviews.html, i.e
> this:
>
> CREATE TABLE mymatview AS SELECT * FROM mytab;
>
> Should instead by
>
> CREATE VIEW mymatview AS SELECT * FROM mytab;
>
No, the example's intent is to compare a true "materialized view" with a
table that is simply populated from a query. The comment "the materialized
view cannot subsequently be directly updated" only makes sense as a
counterpoint to a physical table.
David J.