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;
