Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo

On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form <noreply@postgresql.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.