Обсуждение: 41.3. Materialized Views: Create table should be create view?

Поиск
Список
Период
Сортировка

41.3. Materialized Views: Create table should be create view?

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/rules-materializedviews.html
Description:

CREATE TABLE mymatview AS SELECT * FROM mytab;

Should be the creation of view instead.

Re: 41.3. Materialized Views: Create table should be create view?

От
"David G. Johnston"
Дата:
On Fri, Apr 8, 2022 at 2:06 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/rules-materializedviews.html
Description:

CREATE TABLE mymatview AS SELECT * FROM mytab;

Should be the creation of view instead.

The documentation is correct.  Its purpose is to contrast a table that got created from a view and a materialized view.

David J.