The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/rules-materializedviews.html
Description:
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;
(I.e, create a VIEW, not a TABLE).
Could also be debated if the view name should be the same in both examples.
I.e the second example might be even better as below:
CREATE VIEW myview AS SELECT * from mytab;