On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form <[email protected]>
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.

Reply via email to