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

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 <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.
>

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