On Fri, Aug 22, 2025, at 23:40, David G. Johnston wrote: > On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form <nore...@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. >
Right, I stand corrected, and realize I don't know enough about standard view. Maybe its the naming of the example *table* with the suffix *view* that completely mess up my brain, but I guess given the intent that's how it should be. Thanks, Erik
