Request a Demo
Home   >   mailing lists

Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Date
Msg-id CAKFQuwZ8pXZ1tBLRn6HXEaK9Gd6JvHk-HzowNGMZ2JPFBO2CzQ@mail.gmail.com
Whole thread Raw
In response to Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
List pgsql-docs
Tree view
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.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Inaccurate statement about log shipping replication mode
Next
From: "Erik Forsberg"
Date:
Subject: Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo